Is there any way to make Excel macros less stupid?
Note that you can also set the formula of a cell using VB (although again, the syntax escapes me off-hand), so if you needed something more flexible, you could have your code assign something like “=E4” as the formula, rather than directly pasting in the new value. That way, once you established that relationship, the new cell would update automatically without having to run the macro again.
