TableRange1 Property

Applies To

PivotTable Object.

Description

Accessor. Returns a Range object that represents the range that contains the entire PivotTable, but does not include page fields. Read-only.

Remarks

The TableRange2 property includes page fields.

Example

This example selects the PivotTable, except that its page fields are not selected.


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