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

    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
    Next

    Hope this makes sense.

    Many Thanks,

    JBee

  2. #2
    Join Date
    Mar 2006
    Posts
    163
    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
  •