J
JamesE
I need a macro to locate a named row, insert a new row (immediately above it)
then copy formula from the named row to the newly created row. At the time of
creating the macro, it identifies the paste destination as an absolute
address, rather than relative to the named row. Consequently, it works only
once and subsequently doesn't copy to the newly created row but to the row it
first created which is specifically addressed in the the macro. Maybe there
is a relative cell movement command I could manually insert in the macro like
"UP"? I've tried various "tricks" including naming the new row, but can't
overcome the macro's capture of the original paste address. Can anybody
suggest a solution?
then copy formula from the named row to the newly created row. At the time of
creating the macro, it identifies the paste destination as an absolute
address, rather than relative to the named row. Consequently, it works only
once and subsequently doesn't copy to the newly created row but to the row it
first created which is specifically addressed in the the macro. Maybe there
is a relative cell movement command I could manually insert in the macro like
"UP"? I've tried various "tricks" including naming the new row, but can't
overcome the macro's capture of the original paste address. Can anybody
suggest a solution?