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 ?