Pane Object

Description

Represents a pane of a window. Pane objects exist only for worksheets and Excel 4.0 macro sheets.

Accessors

The Pane object is a member of the Panes collection. The Panes collection contains all of the panes shown in a single Window. To access a single member of the collection, use the Panes method with the pane index number as an argument. The following example splits the window showing worksheet one and then scrolls the pane in the lower-left corner to position row five at the top.


Worksheets(1).Activate
ActiveWindow.Split = True
ActiveWindow.Panes(3).ScrollRow = 5

Properties

Application Property, Creator Property, Index Property, Parent Property, ScrollColumn Property, ScrollRow Property, VisibleRange Property.

Methods

Activate Method, LargeScroll Method, SmallScroll Method.