excel sheet opens showing the very bottom row with data

Occasional Visitor

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 bottom.

 

Can this be done?

 

Danny

1 Reply
@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.