共用方式為


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

請參閱

概念

PivotTable Object

PivotTable Object Members