- Oct 15, 2002
- Office Version
I've got the Macro blues. I'm trying to get VBA to insert a new line at the foot of a Worksheet range, then copy the contents of the last line into the newly created blank line. Problem is trying to make this repeatable, as when I run the macro a second time, all the cell references point to the line number which was active when I recorded the macro, and it simply overwrites the previous line. Can anyone suggest a way to increment the line numbers used each time a macro is run?