PivotTable.TableRange1 Property

Syntax

expression.TableRange1

expression A variable that represents a PivotTable object.

Remarks

The TableRange2 property includes page fields.

Example

This example selects all of the PivotTable report except its page fields.

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

Pivottable area excluding page fields? Return the range containing the entire pivottable? table Table Range 1 Property table range1 TableRange1 TableRange1 Property

Returns a Range object that represents the range containing the entire PivotTable report, but doesn't include page fields. Read-only.

See also: