Pane Object

Remarks

Pane objects exist only for worksheets and Microsoft Excel 4.0 macro sheets. The Pane object is a member of the Panes collection. The Panes collection contains all of the panes shown in a single window.

Example

Use Panes(), where is the pane index number, to return a single Paneobject. The following example splits the window in which worksheet one is displayed and then scrolls through the pane in the lower-left corner until row five is at the top of the pane.

Worksheets(1).Activate ActiveWindow.Split = True ActiveWindow.Panes(3).ScrollRow = 5

See also:

• Excel Object Model Reference
• Pane Object Members