View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy Wilkinson[_2_] Andy Wilkinson[_2_] is offline
external usenet poster
 
Posts: 1
Default 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