Expand Minimize

PivotTable.TableRange2 Property (Excel)

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

expression .TableRange2

expression A variable that represents a PivotTable object.

The TableRange1 property doesn’t include page fields.

This example selects the entire PivotTable report, including its page fields.

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

Community Additions

ADD
Show:
© 2014 Microsoft