Expand Minimize

PivotTable.TableRange1 Property (Excel)

Returns a Range object that represents the range containing the entire PivotTable report, but doesn’t include page fields. Read-only.

expression .TableRange1

expression A variable that represents a PivotTable object.

The TableRange2 property includes page fields.

This example selects all of the PivotTable report except its page fields.

Worksheets("Sheet1").Activate 
Range("A3").PivotTable.TableRange1.Select
Show:
© 2015 Microsoft