View Full Version : Calculate how many items are in the data field
Djblois
03-16-2007, 06:36 PM
I use pivot tables im my Add-in to create reports for my company and I need to find a way through VBA to calculate how many fields have been added to the datafield of the Pivot table class. I need to do this because I want to change the datafield to a column field if more than 1 is added.
Djblois
03-17-2007, 10:18 AM
bump
geekgirlau
03-18-2007, 10:30 PM
Dim pvtTable As PivotTable
Set pvtTable = Worksheets("Pivot").Range("A4").PivotTable
Debug.Print pvtTable.DataFields.Count
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.