Expand Minimize

Window.ScrollColumn Property (Excel)

Returns or sets the number of the leftmost column in the pane or window. Read/write Long.

expression .ScrollColumn

expression A variable that represents a Window object.

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

This example moves column three so that it's the leftmost column in the window.

Worksheets("Sheet1").Activate 
ActiveWindow.ScrollColumn = 3
Show:
© 2014 Microsoft