| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
PivotField.DataRange property (Excel) |
vbaxl10.chm240078 |
|
|
14d5e4c4-1acb-aa02-6694-28e358afc881 |
05/04/2019 |
medium |
Returns a Range object as shown in the following table. Read-only.
expression.DataRange
expression A variable that represents a PivotField object.
| Object | Data range |
|---|---|
| Data field | Data contained in the field |
| Row, column, or page field | Items in the field |
| Item | Data qualified by the item |
This example selects the PivotTable items in the field named REGION.
Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
Worksheets("Sheet1").Activate
pvtTable.PivotFields("REGION").DataRange.Select[!includeSupport and feedback]