SPLIT macro

Equivalent to choosing the Split command from the Window menu or to dragging the split bar in the active window's scroll bar. Splits the active window into panes. Use SPLIT when you want to view different parts of the active sheet at the same time.

Syntax

SPLIT(col_split, row_split)

Col_split    specifies where to split the window vertically and is measured in columns from the left of the window.

Row_split    specifies where to split the window horizontally and is measured in rows from the top of the window.

If an argument is 0 and there is a split in that direction, the split is removed. If an argument is omitted, a split in that direction is not changed.

Related Function

FREEZE.PANES   Freezes or unfreezes the panes of a window

Return to index