Pane Object [Excel 2003 VBA Language Reference]

  • Article
Multiple objects
Pane
Range

Represents a pane of a window. Pane objects exist only for worksheets and Microsoft Excel 4.0 macro sheets. The Pane object is a member of the Panes collection. The Panes collection contains all of the panes shown in a single window.

Using the Pane Object

Use Panes(index), where index is the pane index number, to return a single Pane object. The following example splits the window in which worksheet one is displayed and then scrolls through the pane in the lower-left corner until row five is at the top of the pane.

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 | ScrollIntoView Method | SmallScroll Method

Parent Objects | Panes Collection | Window Object

Child Objects | Range Object