PivotLocation Members
Contains information about the location of a pivot table and its areas.Properties
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