Window.SplitRow Property (Excel)
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.
Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate
ActiveWindow.SplitRow = 10