How to select and count elements in a PivotTable with VBA

[joseluis12]

Hello to all of you!

I have this PivotTable PivotTable1.jpg where I need to count the number of dates for each month for certain customer ( In the example: 6 dates in the month "1" of the Customer named "Modular Tops, S. de R.L.". So far i have tried with this code:

Please Login or Register  to view this content.

So far without any luck (I´m using Excel 2007). I have include the excel file with the data.

¿Could you help me find what I am missing? Thank you all in advance!

Regards

José Luis