PivotField.DataRange Property (Excel)
Returns a Range object as shown in the following table. Read-only.
Syntax
expression .DataRange
expression A variable that represents a PivotField object.
Remarks
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