Expand Minimize

Window.SplitHorizontal Property (Excel)

Returns or sets the location of the horizontal window split, in points. Read/write Double.

expression .SplitHorizontal

expression A variable that represents a Window object.

This example sets the horizontal split for the active window to 216 points (3 inches).

Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate 
ActiveWindow.SplitHorizontal = 216
Show:
© 2014 Microsoft