Blank Row

[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

 

[Mike]

This will select the next available cell in column A.

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

 

[Mike Scobie]

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