Excel.Window.Panes.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Window.Panes property (Excel)	vbaxl10.chm356101	vbaxl10.chm356101	Excel.Window.Panes	ba89f562-66f8-990d-e034-c996557b3687	05/21/2019	medium

Window.Panes property (Excel)

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

[!includeSupport and feedback]