View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Code to go to last row (next blank row)

if the determination can be made on column A

cells(rows.count,1).end(xlup)(2).Select

--
Regards,
Tom Ogilvy


miker1999 wrote in 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/