Skip to main content
Row

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