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
|