View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Juan Carlos Juan Carlos is offline
external usenet poster
 
Posts: 3
Default Question on Macros

I have a macro that is moving data from on sheet to another.

For example the macro below will move everything that is in l51down to n2.

Sheets("sheet1").Range("l51:l" & Trim(Str(20 + iRows))).Copy
Sheets("sheet3").Range("n2:n" & Trim(Str(3 + iRows))).PasteSpecial
Paste:=xlPasteValues

How can I move more data to sheet 3 that will automatically put the data in
the last row where the previous data was placed?

Thanks