Pages Object (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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.

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. _ 

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 _