On May 27, 8:52*pm, Rugby Stud
wrote:
Check out:http://www.mrexcel.com/articles/copy...-blank-row.php



"Bobby J" wrote:
I'm writing a macro to cut and paste data to the next blank row in an Excel
file. *Any ideas?- Hide quoted text -

- Show quoted text -

Use this

Range("A1").end(xldown).offset(1,0).select
Activesheet.paste


Regards
Rakesh