Partager via


PivotTable.TableRange2 Property

Returns a Range object that represents the range containing the entire PivotTable report, including page fields. Read-only.

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

Syntax

'Declaration
ReadOnly Property TableRange2 As Range
    Get
'Usage
Dim instance As PivotTable
Dim value As Range

value = instance.TableRange2
Range TableRange2 { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.Range

Remarks

The TableRange1 property doesn’t include page fields.

See Also

Reference

PivotTable Interface

PivotTable Members

Microsoft.Office.Interop.Excel Namespace