DataRange Property [Excel 2003 VBA Language Reference]
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
Applies to | PivotField Object | PivotItem Object