PageRangeCells Property

Microsoft Excel Visual Basic

PageRangeCells Property

       

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

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