Share via

PivotItem.DataRange Property

  • Article
Excel Developer Reference

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."

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

See Also