| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
PivotItem.DataRange property (Excel) |
vbaxl10.chm246075 |
|
|
6946f4eb-60ef-0d7a-394a-cd7904967a02 |
05/07/2019 |
medium |
Returns a Range object as shown in the following table. Read-only.
expression.DataRange
expression A variable that represents a PivotItem 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]