Hello to All,

I have a trouble running a macro in mac excel 2010 (mine) but fails in Windows Excel 2007 (my boss). Could you help me understand where is my error?

I have a PivotTable (please see Pict1) PivotTable1.jpg with Customer names, Months and payment dates. I want to show the number of payments recieved each month in another sheet (please see Pict2) PICT2.jpg. Delivers results on Mac but none in Windows, . The code I´m using is the following: 
Please Login or Register  to view this content.
I have tried "LabelRange" following the advice of this page...
http://peltiertech.com/WordPress/ref...ranges-in-vba/
but i feel i´m missing something...

Could you please help me discover where is my mistake? Thanks in advance...

Best regards

Jose Luis