Item Property (Panes Collection)

Applies To

Panes collection object.

Description

Returns a single Pane object from a Panes collection.

Syntax

expression.Item(Index)

expression Required. An expression that returns a Panes object.

Index Required Long. The index number of the pane.

Example

This example splits the window in which worksheet one is displayed and then scrolls through the pane in the lower-left corner of the window until row five is at the top of the pane.

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