Pages Object

Version Information
Version Added: Excel

Remarks

Use the Pages property to return a Pages collection. The following example accesses all pages in the active worksheet.

Dim objPages As Pages Set objPage = ActiveWorksheet. _ ActiveWindow.Panes(1).Pages

Use the Item method to access an individual Page object that represents an individual page in a worksheet. The following example accesses the first page in the active worksheet.

Dim objPage As Page Set objPage = ActiveWorksheet.ActiveWindow _ .Panes(1).Pages.Item(1)

See also:

• Excel Object Model Reference
• Pages Object Members