Panes Collection Object

Description

A collection of all the Pane objects shown in the specified window. Pane objects exist only for worksheets and Excel 4.0 macro sheets.

Accessors

Use the Panes method with an argument to access a single member of the collection or without an argument to access the entire collection at once.

The following example scrolls the upper-left pane of the window showing the worksheet named "Sheet1."


Worksheets("sheet1").Activate
Windows(1).Panes(1).LargeScroll down:=1

Properties

Application Property, Count Property, Creator Property, Parent Property.

Methods

Item Method.