Applies To
PivotField Object, PivotItem Object.
Description
Accessor. Returns a Range object as shown in the following table. Read-only.
|
Object |
DataRange |
|
Data field |
Data contained in the field |
|
Row, Column, or Page field |
Items in the field |
|
Item |
Data qualified by the item |
Example
This example selects the pivot items in the field named "REGION."
Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
Worksheets("Sheet1").Activate
pvtTable.PivotFields("REGION").DataRange.Select