Returns a Range object as shown in the following table. Read-only.
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 |
Example
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