what VBA command is used to go to the next blank row in Excel?

[Bobby J]

I'm writing a macro to cut and paste data to the next blank row in an Excel
file. Any ideas?

 

[Ron de Bruin]

Hi Bobby

See how I do it here
http://www.rondebruin.nl/copy1.htm

 

[Rugby Stud]

Check out:
http://www.mrexcel.com/articles/copy-to-next-blank-row.php

 

[Don Guillett]

Depends of what you want. No difference IF no blanks

nextblankrow=cells(activecell.row,"a").end(xldown).row+1
lastblankrow=cells(rows.count,"a").end(xlup).row+1

 

[Rakesh Sharma]

Check out:http://www.mrexcel.com/articles/copy-to-next-blank-row.php





- Show quoted text -

Use this

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


Regards
Rakesh