PivotTable and PivotTable Report Differences?

[Budman50]

I am creating a number of excel spreadsheets with some summary data, including a pivot table and pivot chart. I have a master datasheet with over 35K rows, I have a sophisticated advanced filter that seperates from this master datasheet into a smaller subset of data, from which I am generating the pivot table and chart.

I am generating 35 different subsets of spreadsheets from this master data set. I have it in a loop and it mostly works. That is, it successfully generates several of the data subsets. However, it stops when the PivotTable Report has less rows than other generated data sets.

I have purchased several books on VBA excel programming, including a specific one in PivotTables and PivotCharts. I am having trouble understanding a few things.

The pivotTable Report is what I see after creating the PivotTable and the Pivotchart. How do I count the number of rows in the pivottable report? How can I detect which pivottable report rows are missing? Or more correctly, present? The pivot table report is a very simple row,colum, two columns and up to five rows of items. The first column is a label and the second the actual data.

All my documentation seems to point to the use of the PivotTable.PivotFields, etc.. However, I find I am referencing the actual master data set within the range of the pivottable, not the PivotTable report itself. MS Documentation states the PivotTable Report is an object of the PivotTable...... helps me very little.

Can some Excel guru explain the differences in accessing the PivotTable Report verses accessing the PivotTable itself? And maybe show me the an example of code that reads the PivotTable Report?

thanks.