Try something like the following:

Cells(Rows.Count, "A").End(xlUp)(2, 1).Select


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"joi2" wrote
in message
...

does anyone know of a way to find the last row in an excel
worksheet
that does data and set the cursor to the next empty cell


--
joi2
------------------------------------------------------------------------
joi2's Profile:
http://www.excelforum.com/member.php...o&userid=27554
View this thread:
http://www.excelforum.com/showthread...hreadid=486948