Edit

PivotTable.PageRangeCells property (Excel)

  • Article

Returns a Range object that represents only the cells in the specified PivotTable report that contain the page fields and item drop-down lists.

Syntax

expression.PageRangeCells

expression A variable that represents a PivotTable object.

Example

This example selects only the cells in the PivotTable report that contain page fields and item drop-down lists.

Worksheets(1).PivotTables(1).PageRangeCells.Select

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.