Thread: Pivot Field Data count
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default Pivot Field Data count
MyPivotTable.PivotFields("MiPivotField").PivotItem s.Count

Mónica wrote:
Does anyone knows the code in VBA to know how many diferent items a pivot
table field has???

I´m looking for something like:

MyPivotTable.PivotFields("MiPivotField").Count



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply With QuoteReply With Quote