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 |