PDA

View Full Version : Solved: Pivot Table



JKwan
06-29-2011, 12:22 PM
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
06-30-2011, 07:25 PM
activesheet.pivottables(1).pivotfields.count

activesheet.pivottables(1).rowfields.count

activesheet.pivottables(1).columnfields.count

activesheet.pivottables(1).pagefields.count



Paul

JKwan
07-05-2011, 06:19 AM
Thanks Paul.