Solved: Pivot Table

[JKwan]

I was wondering.... How do I get the number of Pivot Fields that are being used in a pivot table (I don't mean the number of fields that are available to be used). For example if the my pivot table have 10 fields that is available for me to use, but I only used 3 of them, I need to know how to get "3".

[Paul_Hossler]

[VBA]
activesheet.pivottables(1).pivotfields.count

activesheet.pivottables(1).rowfields.count

activesheet.pivottables(1).columnfields.count

activesheet.pivottables(1).pagefields.count

[/VBA]

Paul

[JKwan]

Thanks Paul.