Hi All,

Hope someone can help with this. I'd like to know how to extract items from a pivot table page field using VBA. For example, say I have several items in my page field relating to products etc, is there a way I can loop through them so I can populate an array or such like. I'm thinking something along the lines of...

For Each Item in Sheet1.PivotTables(1).PivotFields("Product") etc...
Debug.Print Item
Next

Hope this makes sense.

Many Thanks,

JBee

Couldn't you just get that information from the raw data?