creating a pivot table, missing data

Hello,

I'm trying to create a pivot table in a new workbook. The only data is one column, 38 rows long, listing months (coppied from another wb). I'm trying to create a pivot table that counts the number of times each month appears:

This is the code I've got (lifted from a recorded macro). When I was recording the macro, it worked. But running the code creates a pivot table with one row that counts the number of entries in the range, not making any differentiation between values.
I'm new to using Pivot Tables in VBA. Any ideas?

Please Login or Register  to view this content.

Thanks for the reply Richard. I managed to find some code online that's solved it. I'm not sure why it works and my code didn't though.

The credit for the code goes to:
http://stackoverflow.com/questions/1...mic-data-range

The code that works in case anyone else is searching for the same problem and needs it:

Please Login or Register  to view this content.