Share via


Window.SplitColumn Property

Excel Developer Reference

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.

Visual Basic for Applications
  Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate
ActiveWindow.SplitColumn = 1.5

See Also