PivotItem.DataRange property (Excel)

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

Syntax

expression.DataRange

expression A variable that represents a PivotItem 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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.