Expand Minimize

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.

expression .PageRangeCells

expression A variable that represents a PivotTable object.

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

Community Additions

ADD
Show:
© 2014 Microsoft