DataRange Property

Microsoft Excel Visual Basic

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