Go back to previous displayed screen

[plans]

Hello,

I am running a code which writes in a certain cell the current active cell address and after that it navigates to a far distant area of the same worksheet.

Next I am running a different code which reads the cell address recorded earlier and selects it, in expectation that I would get back to the screen display I quit but what I am getting is the cell selected but not the display I had when I navigated away from the cell; I am just getting a portion of the earlier screen.

Is there a way to return to the last display instead of just returning to the last cell?

Please advise.

Thank you

[AlphaFrog]

Can you show your code that stores the activecell address and later goes back to it?

[plans]

Hello AlphaFrog,
Here are the codes:

Sub Store()   
    ActiveWindow.FreezePanes = False
    ActiveSheet.Range("LastCell").Value = ActiveCell.Address
    Application.Goto Range("StartCateg"), Scroll:=True
End Sub

Sub GoBack()
Dim LastCellAddress As String   
    LastCellAddress = ActiveSheet.Range("LastCell").Value
    Application.Goto (ActiveSheet.Range(LastCellAddress))       
End Sub

Thanks for looking into this!

[AlphaFrog]

Public SR As Long
Public SC As Long

Sub Store()
    ActiveWindow.FreezePanes = False
    SR = ActiveWindow.ScrollRow
    SC = ActiveWindow.ScrollColumn
End Sub

Sub GoBack()
    If SR > 0 And SC > 0 Then
        ActiveWindow.ScrollRow = SR
        ActiveWindow.ScrollColumn = SC
    End If
End Sub