Thread: Pivotitem count
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jesse[_4_] Jesse[_4_] is offline
external usenet poster
 
Posts: 15
Default Pivotitem count

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

I tried

Activesheet.PivotTables("BDStore").PivotField("Sto re").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.