Skip to main content

PivotTable.TableRange2 property

Table of contents
  1. Syntax
  2. Remarks
  3. Example

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

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.

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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>