G
Guest
Greetings, Just recording a macro to insert a column in the middle of some
data, enter a formula and then copy the formula to cells below (having some
problems with blank rows screwing this up but I'll leave that for another
question). The number of rows in this data will vary, the recorded macro
looks at what cell I move cursor to rather than just going right one cell or
end down. How can I get around this, do I have to record the macro and then
manually edit it to move one cell to right or end down where it has selected
a cell address?
Thanks.
data, enter a formula and then copy the formula to cells below (having some
problems with blank rows screwing this up but I'll leave that for another
question). The number of rows in this data will vary, the recorded macro
looks at what cell I move cursor to rather than just going right one cell or
end down. How can I get around this, do I have to record the macro and then
manually edit it to move one cell to right or end down where it has selected
a cell address?
Thanks.