PivotLocation Properties
Contains information about the location of a pivot table and its areas.| Name | Description |
|---|---|
| ColumnRange | Gets the cell range that contains the column area of the PivotTable report. |
| DataRange | Gets the cell range that contains the data area of the PivotTable report. |
| PageRange | Gets the cell range that contains the page area of the PivotTable report. |
| Range | Gets the cell range that contains the entire PivotTable report except for the page area. |
| RowRange | Gets the cell range that contains the row area of the PivotTable report. |
| WholeRange | Gets the cell range that contains the entire PivotTable report including the page area. |
See Also