(xldown) Next Blank Row

[redsoxfan89]

Hi,

I created a macro (shown below)in VBA to export data from an excel spreadsheet to another spreadsheet. When I use this code, it works beautifully, but the new data that is transferred overwrites the data I had previously exported. Is there a way to make it so that the new data comes in the row of cells below the old data? Can you manipulate my code so it works? Thanks.

Macro1 ()

Selection.Copy
Windows("AASHISH_PROJECT_TEST.xls").Activate
Sheets("CP").Select
Range("A3").Select
Sheets("CP").Paste
End Sub

 

[Andrew Poulsom]

Duplicate:

http://www.mrexcel.com/board2/viewtopic.php?t=286980