Hi,
I am looking for a way in VB to select and unselect items in the list for filters generated in a pivot table.item list.
Ho do I do that?
Hi,
I am looking for a way in VB to select and unselect items in the list for filters generated in a pivot table.item list.
Ho do I do that?
Last edited by TPFKAS; 01-10-2010 at 09:39 AM.
Bump...
Really nobody ?
Dear TPFKAS,
If you send me a non-confidential version of your pivot, I can help.
The application I build is a bit too extended and complex to post over here. So, attached there is an example sheet with a pivot table. I'd like to hide the empty records so I would have to deselect the value empty in the column Name.
In basic terms:
obviously modify as required per locale etc (ie Blank etc...)Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
OK. Thnkx alot for the prompt reply.
Closed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks