ScrollColumn Property

Microsoft Excel Visual Basic

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

Remarks

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.

Example

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

Worksheets("Sheet1").Activate
ActiveWindow.ScrollColumn = 3