Edit

Share via

PivotTable.TableRange2 property (Excel)

  • Article

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.