DataRange Property

Applies To

PivotField object, PivotItem object.

Description

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 pivot items in the field named "REGION."

Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
Worksheets("Sheet1").Activate
pvtTable.PivotFields("REGION").DataRange.Select