Pasting after last record
Hi all
I am cutting and pasting between worksheets using a macro and need to add
records to the end of a list, i.e. have already pasted 2000 rows, and want to
paste starting from row 2001, but am not able to specify the row number as it
varies every time.
Is there a vba command that will automatically paste after last row?
Thanks in advance
Andy
|