PivotLocation Properties
Contains information about the location of a pivot table and its areas.
Name | Description |
---|---|
Column |
Gets the cell range that contains the column area of the Pivot |
Data |
Gets the cell range that contains the data area of the Pivot |
Page |
Gets the cell range that contains the page area of the Pivot |
Range |
Gets the cell range that contains the entire Pivot |
Row |
Gets the cell range that contains the row area of the Pivot |
Whole |
Gets the cell range that contains the entire Pivot |
See Also