Copy data to excel below existing data

Closed
dhana - Apr 8, 2010 at 03:58 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 8, 2010 at 07:13 AM
Hi,

I want to copy the data from some other source to the excel. The copied data should get pasted few rows below the existing data.

Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 8, 2010 at 07:13 AM
Since you have not provided much detail, the most versatile and adabtable answer would be find out the last row that was used earlier

lLastRows = Cells(row.count, "A").end(xlup).row
this assumed that max used rows are in column A, change it to suit u

The paste it from after this row, Use macro recorder to assist u
0