PivotTable.TableRange2 Property (Excel)
Returns a Range object that represents the range containing the entire PivotTable report, including page fields. Read-only.
Syntax
expression .TableRange2
expression A variable that represents a PivotTable object.
Remarks
The TableRange1 property doesn’t include page fields.
Example
This example selects the entire PivotTable report, including its page fields.
Worksheets("Sheet1").Activate
Range("A3").PivotTable.TableRange2.Select