View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Code to go to last row (next blank row)

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/

.