G
Guest
Guest
I have a macro which copies a column of data (variable length) to a certain part of a spreadsheet. I want to select the range and apply a name to it. When I use the Select Current Region option, it is recorded in the macro with the precise cell references, which is no use when running the macro for a list of a different length. Also, it cannot record the keystrokes of holding the tab down and pressing END.
Can anyone help?
Thanks, Andrew
Can anyone help?
Thanks, Andrew