DataRange Property

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