Pages object (Excel)

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.

Remarks

Use the Pages property of the PageSetup object to return a Pages collection. The following example accesses all pages on 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 on a worksheet. The following example accesses the first page on the active worksheet.

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

Properties

• Count
• Item

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.