VBA Scroll to top (not left)

Question

I am trying to write a command that scrolls the current ActiveCell to the top of the page.

As Activecell is in column C, if I use the below code it moves A & B out of sight.

How do I use active cell to scroll up without moving A & B out of the field of view.

Thanks

Application.Goto ActiveCell, Scroll:=True

user_7132550 · Answer

Just try:

Sub Scroll()
    ActiveWindow.ScrollRow = ActiveCell.Row
End Sub