PivotTable.TableRange2 Property

Syntax

expression.TableRange2

expression A variable that represents a PivotTable object.

Remarks

The TableRange1 property doesn't include page fields.

Example

This example selects the entire PivotTable report, including its page fields.

Visual Basic for Applications
`Worksheets("Sheet1").Activate Range("A3").PivotTable.TableRange2.Select`

Pivottable range including page fields? Return the range containing the entire pivottable? Table Range 2 Property table range2 TableRange2 TableRange2 Property

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

See also: