Edit

Share via

Window.Panes property (Excel)

  • Article

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

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.

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.