Pages Object

  • Article
Excel Developer Reference

A collection of pages in a document. Use the Pages collection and the related objects and properties for programmatically defining page layout in a workbook.

Version Information
 Version Added:  Excel 2007

Remarks

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

Visual Basic for Applications 
  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.

Visual Basic for Applications 
  Dim objPage As Page

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

See Also