Window.ScrollColumn Property

Excel Developer Reference

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

Syntax

expression.ScrollColumn

expression   A variable that represents a Window object.

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.

Visual Basic for Applications
  Worksheets("Sheet1").Activate
ActiveWindow.ScrollColumn = 3

See Also