| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
PivotTable.TableRange1 property (Excel) |
vbaxl10.chm235098 |
|
|
4dfea643-3299-82ee-a770-b961904eec7f |
05/09/2019 |
medium |
Returns a Range object that represents the range containing the entire PivotTable report, but doesn't include page fields. Read-only.
expression.TableRange1
expression A variable that represents a PivotTable object.
The TableRange2 property includes page fields.
This example selects all of the PivotTable report except its page fields.
Worksheets("Sheet1").Activate
Range("A3").PivotTable.TableRange1.Select[!includeSupport and feedback]