Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Manchester, England

    Unanswered: Extract Page Field Items from a Pivot Table?

    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

    Hope this makes sense.

    Many Thanks,


  2. #2
    Join Date
    Mar 2006
    Couldn't you just get that information from the raw data?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts