Blank Row

  • Thread starter Thread starter Graham
  • Start date Start date
G

Graham

I need a quick bit of code please. If I have data in
Columns A:I which I wish to keep adding to via macro;what
would be the code to find the next blank row and make it
the active row ready to receive the next batch of pasted
data.

Help much appreciated.
Thanks
Graham
 
This will select the next available cell in column A.

Range("A" & Range("A65536").End(xlUp).Rows+1).Select
 
Hi Graham,

Give this a bash:

range("a1").end(xldown).offset(1,0).activate

Do you work at Search in Edinburgh with Justin?

Regards,

Mike
 
Back
Top