Pivotitem count

  • Thread starter Thread starter Jesse
  • Start date Start date
J

Jesse

Try as I might I can't get the count of items in a pivot field.

I tried

Activesheet.PivotTables("BDStore").PivotField("Store").pivotitems.count

But that returns object doesn't support this property or method.

The pivotitems object does have a count property but I'm suspecting I'm not
using it correctly.
 
try adding an "s" to PivotField --

ActiveSheet.PivotTables("BDStore").PivotFields("Store").PivotItems.Count
 
I got it working, that with another error I had fixed it.

Pretty much a user problem <grin>

Jesse
 
Back
Top