PivotTable.TableRange1 Property
Returns a Range object that represents the range containing the entire PivotTable report, but doesn’t include page fields. Read-only.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
ReadOnly Property TableRange1 As Range
Get
'Usage
Dim instance As PivotTable
Dim value As Range
value = instance.TableRange1
Range TableRange1 { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.Range
Remarks
The TableRange2 property includes page fields.