Excel.PivotTable.PageRangeCells.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotTable.PageRangeCells property (Excel)	vbaxl10.chm235088	vbaxl10.chm235088	Excel.PivotTable.PageRangeCells	1c3b0694-539a-7d2d-17df-c0c0405d19e6	05/09/2019	medium

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

[!includeSupport and feedback]