Returns or sets the number of the leftmost column in the pane or window. Read/write Long.
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