Panes Property

Microsoft Excel Visual Basic

Returns a Panes collection that represents all the panes in the specified window. Read-only.

For information about returning a single member of a collection, see Returning an Object from a Collection.

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.

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.

Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate
ActiveWindow.Panes(1).Activate