Share via

TableRange1 Property [Excel 2003 VBA Language Reference]

  • Article

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

Remarks

The TableRange2 property includes page fields.

Example

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

Worksheets("Sheet1").Activate
Range("A3").PivotTable.TableRange1.Select

Applies to | PivotTable Object