PivotTable.PageRangeCells Property (Excel)
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