Window.Panes Property

  • Article
Excel Developer Reference

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.

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

See Also