Edit

Share via

PivotTable.TableRange1 property (Excel)

  • Article

Returns a Range object that represents the range containing the entire PivotTable report, but doesn't include page fields. Read-only.

Syntax

expression.TableRange1

expression A variable that represents a PivotTable object.

Remarks

The TableRange2 property includes page fields.

Example

This example selects all of the PivotTable report except its page fields.

Worksheets("Sheet1").Activate 
Range("A3").PivotTable.TableRange1.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.