Panes Collection
The document is archived and information here might be outdated

Panes Collection Object [Excel 2003 VBA Language Reference]

Office 2003
Window
Panes
Pane
Range

A collection of all the Pane objects shown in the specified window. Pane objects exist only for worksheets and Microsoft Excel 4.0 macro sheets.

Using the Panes Collection

Use the Panes property to return the Panes collection. The following example freezes panes in the active window if the window contains more than one pane.

If ActiveWindow.Panes.Count > 1 Then _
    ActiveWindow.FreezePanes = True
		

Use Panes(index), where index is the pane index number, to return a single Pane object. The following example scrolls through the upper-left pane of the window in which Sheet1 is displayed.

Worksheets("sheet1").Activate
Windows(1).Panes(1).LargeScroll down:=1
		


Parent Objects | Window

Child Objects | Range


Show:
© 2016 Microsoft