PageRangeCells Property

Applies To

PivotTable object.

Description

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

Example

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

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