AbaZum
07-24-2019, 06:16 AM
Hello!
I want to use from a pivot table field the dropdown option of "Add curent selection to filter" in VBA code.
When i'm in that dropdown were you can select what PivotItems you want, i want to search for something there, deselect "Select All Search Results" and select "Add current selection to filter".
All of these actions done in VBA code. I want them to be done automatically not manually.
Please help! I've tried with loops to set visible and no-visible the pivotitems but this method is slow and it dosen't work like when i do it manually.
Thank you !
I want to use from a pivot table field the dropdown option of "Add curent selection to filter" in VBA code.
When i'm in that dropdown were you can select what PivotItems you want, i want to search for something there, deselect "Select All Search Results" and select "Add current selection to filter".
All of these actions done in VBA code. I want them to be done automatically not manually.
Please help! I've tried with loops to set visible and no-visible the pivotitems but this method is slow and it dosen't work like when i do it manually.
Thank you !