Forum Discussion

DanDavBar's avatar
DanDavBar
Copper Contributor
Jun 24, 2021

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

 

Can this be done?

 

Danny

excel

1 Reply

  • Shozab's avatar
    Shozab
    Brass Contributor
    Jun 24, 2021
    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.

Resources