Share via


PivotItem.DataRange Property

Returns a Range object. Read-only.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
ReadOnly Property DataRange As Range
    Get
'Usage
Dim instance As PivotItem
Dim value As Range

value = instance.DataRange
Range DataRange { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.Range

Remarks

The DataRange property returns the following, depending on the object:

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

See Also

Reference

PivotItem Interface

PivotItem Members

Microsoft.Office.Interop.Excel Namespace