Panes Object

Remarks

Pane objects exist only for worksheets and Microsoft Excel 4.0 macro sheets.

Example

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(), where is the pane index number, to return a single Paneobject. 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

See also:

• Excel Object Model Reference
• Panes Object Members