go last row when file is opened

[Wanna Learn]

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

 

[Mike H]

Hi,

there are several ways and you would need to be more secific to get a
precise answer but this select the cell after the last used cell in column A

Private Sub Workbook_Open()
ActiveSheet.Cells(Rows.Count, 1).End(xlUp)(2).Select
End Sub

Mike

 

[Bob I]

Use a macro to go to last cell, then Ctrl+Home, then down one.

 

[Shane Devenshire]

Hi,

Without programming you might try pressing Ctrl+End and then Home.

This will work in certain situations.

You have provided very few details - does the whole row need to be blank or
only certain cells, which column in the empty row do you want to go to, A or
IV? How is your data set up on the sheet - is it solid or is every other row
blank, or something else? What if you are on the wrong sheet? Do you want
to count cells with formats or just cells with data when you are considering
a blank row?

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[Gord Dibben]

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