Window.ScrollRow Property (Excel)

Returns or sets the number of the row that appears at the top of the pane or window. Read/write Long.

expression .ScrollRow

expression A variable that represents a Window object.

If the window is split, the ScrollRow property of the Window object refers to the upper-left pane. If the panes are frozen, the ScrollRow property of the Window object excludes the frozen areas.

This example moves row ten to the top of the window.

Worksheets("Sheet1").Activate 
ActiveWindow.ScrollRow = 10
Show: