That statement will give the wrong result if A1 is empty.

Rick


"Bob Phillips" wrote in message
...
Range("A1").End(xlDown).Offset(1,0).Address

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"kleysonr" wrote in message
...
How can i get the number of the first empty row in a column ?