Forum Discussion
excel sheet opens showing the very bottom row with data
Hello My goal is to have a spreadsheet file be configured to always open and automatically jump to the bottom row that has data. No short cut keys, no scrolling down. Just auto jumps to the ...
DanDavBar
Hello Danny,
This can be done by placing short code in VBA.
Open VBA Editor with ALT+F11
Private Sub Workbook_Open()
Dim lr As Long, scrlrw As Long
With ActiveSheet
lr = .Range("A" & .Rows.Count).End(xlUp).Row
scrlrw = IIf(lr > 10, lr - 10, 1)
Application.Goto Reference:=.Range("A" & lr + 1)
ActiveWindow.ScrollRow = scrlrw
End With
End Sub
Copy code as it is and save it.
Regards.
Hello Danny,
This can be done by placing short code in VBA.
Open VBA Editor with ALT+F11
Private Sub Workbook_Open()
Dim lr As Long, scrlrw As Long
With ActiveSheet
lr = .Range("A" & .Rows.Count).End(xlUp).Row
scrlrw = IIf(lr > 10, lr - 10, 1)
Application.Goto Reference:=.Range("A" & lr + 1)
ActiveWindow.ScrollRow = scrlrw
End With
End Sub
Copy code as it is and save it.
Regards.