Pivot Field Data count
 

Hello,

Does anyone knows the code in VBA to know how many diferent items a pivot
table field has???

I´m looking for something like:


MyPivotTable.PivotFields("MiPivotField").Count

Thank you in advanced.

Mónica

Pivot Field Data count
 

MyPivotTable.PivotFields("MiPivotField").PivotItem s.Count

Mónica wrote:
Does anyone knows the code in VBA to know how many diferent items a pivot
table field has???

I´m looking for something like:

MyPivotTable.PivotFields("MiPivotField").Count



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html