Window.SplitRow Property

Excel Developer Reference

Returns or sets the row number where the window is split into panes (the number of rows above the split). Read/write Long.

Syntax

expression.SplitRow

expression   A variable that represents a Window object.

Example

This example splits the active window so that there are 10 rows above the split line.

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

See Also

• Window Object
• Window Object Members
• SplitColumn Property
• SplitHorizontal Property
• SplitVertical Property