This documentation is archived and is not being maintained.

PivotField.DataRange Property

Office 2007
Returns a Range object as shown in the following table. Read-only.

Syntax

expression.DataRange

expression   A variable that represents a PivotField object.

Remarks

ObjectData range
Data fieldData contained in the field
Row, column, or page fieldItems in the field
ItemData qualified by the item

Example

This example selects the PivotTable items in the field named "REGION."

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



Show: