Pivot Table Object and the Pivot Tables Collection

The PivotTables collection contains the collection of PivotTables in the parent worksheet. Each PivotTable object in the collection allows manipulation and creation of Excel PivotTables. The parent of the PivotTables collection is the Worksheet object.

The PivotTables collection has an Add method besides the typical collection attributes. The Add method takes a new PivotTable cache (containing the data) and the destination single cell range determining the upper-left corner of the PivotTable report to create a new PivotTable report. The name of the new PivotTable report can also be specified in the Add method.

0 0

Post a comment