TableRange2 Property

Applies To

PivotTable Object.

Description

Accessor. Returns a Range object that represents the range that includes the entire PivotTable, including page fields. Read-only.

Remarks

The TableRange1 property does not include page fields.

Example

This example selects the PivotTable, including its page fields.


Worksheets("Sheet1").Activate
Range("A3").PivotTable.TableRange2.Select