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 

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.