I am trying to write VBA code to read the values of a page field as set by the user. The field has EnableMultiplePageItems set to TRUE. When I read the CurrentPage property, the item returned is "(All)". It is the only VisibleItems and all of the other PivotItems have Visible set to False. Here is my code:
Any help on how I determine which PivotItems are a part of the filter would be appreciated.
Please Login or Register to view this content.
If as implied you're using XL2007, iterate all PivotItems and check Visible status
Please Login or Register to view this content.
It's not clear how you are invoking / utilising the UDF (ie whether or not you need to make it Volatile)
(prior to XL2007 you would need to alter the orientation of the Page Field to that of a Row/Column Field and iterate accordingly)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks