Maybe one row after?, for the "next blank row":
ActiveCell.SpecialCells(xlLastCell).offset(1,0).Se lect
--
Rgds
Max
xl 97
----------------------------------
Use xdemechanik <atyahoo<dotcom for email
-----------------------------------------
"mern" wrote in message
...
ActiveCell.SpecialCells(xlLastCell).Select
-----Original Message-----
Hi all,
I would like to create a command botton (macro) that
would bring the
user to the last row (which is typically the next blank
row) so they
can input data in that row.
I am stuck...thanks!
---
Message posted from http://www.ExcelForum.com/
.