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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.