Version Ref: Version 6.2 (USP 6.1.02)
Syntax:
e = XL_SPLITPANE([vertical [, horizontal [, sheet]]])
Divide a worksheet into horizontal or vertical regions.
Parameters -
vertical: The position for the vertical split. e.g. "1", "12.5", "15"
horizontal: The position for the horizontal split. e.g. "1", "12.5", "15"
sheet: Handle to sheet to freeze the cell on. Leave blank, "0", or "-1"
to use the default sheet.
Returns "1" on success and "-1" on error. XL_ERROR() can be called to return
the last error.
This function divides a worksheet into horizontal or vertical regions known
as panes. This function is different from the XL_FREEZEPANE function in that
the splits between the panes will be visible to the user and each pane will
have its own scroll bars.
The parameters vertical and horizontal are used to specify the vertical and
horizontal position of the split. The units for vertical and horizontal are
the same as those used by Excel to specify row height and column width.
However, the vertical and horizontal units are different from each other.
Therefore you must specify the vertical and horizontal parameters in terms
of the row heights and column widths that you have set or the default values
which are 15 for a row and 8.43 for a column.