View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default go last row when file is opened

Assuming Column A would contain the last row.

Private Sub Workbook_Open()
ActiveSheet.Cells(Rows.Count, 1).End(xlUp) _
.Offset(1, 0).Select
End Sub

Right-click on the Excel Icon left of "File" on the worksheet menubar.

Select "View Code" Paste the above into that module.

Alt + q to return to the Excel window.

Save and close. Reopen to find activecell at first blank cell below data in
column A


Gord Dibben MS Excel MVP

On Tue, 2 Dec 2008 12:02:07 -0800, Wanna Learn
wrote:

Hello Whenever the workbook is opened I the cursor to go to the next
empty row. How do I do that? thanks