Window.SplitColumn Property (Excel)

Returns or sets the column number where the window is split into panes (the number of columns to the left of the split line). Read/write Long .

Syntax

expression. SplitColumn

expression A variable that represents a Window object.

Example

This example splits the window and leaves 1.5 columns to the left of the split line.

Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate 
ActiveWindow.SplitColumn = 1.5

See also

Window Object