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

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

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

Hi Bobby

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Bobby J" <Bobby wrote in message ...
I'm writing a macro to cut and paste data to the next blank row in an Excel
file. Any ideas?

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

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?

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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bobby J" <Bobby wrote in message
...
I'm writing a macro to cut and paste data to the next blank row in an
Excel
file. Any ideas?

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

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