Syntax

expression.Panes

expression A variable that represents a Window object.

Remarks

This property is available for a window only if the window's Split property can be set to True.

Example

This example displays the number of panes in the active window in Book1.xls.

Visual Basic for Applications 
Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate MsgBox "There are " & ActiveWindow.Panes.Count & _ " panes in the active window"

This example activates the pane in the upper-left corner of the active window in Book1.xls.

Visual Basic for Applications 
Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate ActiveWindow.Panes(1).Activate
Collection of panes? Get a list of all the panes in the current window? panes panes property

See also: