PivotTable.PageRangeCells Property

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.

Visual Basic for Applications
`Worksheets(1).PivotTables(1).PageRangeCells.Select`

Find out location of all pagefield cells in a pivottable? page range cells Page Range Cells Property PageRange PageRangeCells PageRangeCells Property Retrieve a list of all page field addresses? Return the range containing only pagefields?

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

See also: