I'm new to VBA and I'm trying to write a simple procedure to alter the filter selections on a Pivot table using VBA.
I am successful in manipulating the page fields (Pivot Filters) on the pivot using the following code, but have no idea on how to manipulate the column or row label field filters on the same table.
Here is the code I have written so far and the Bold statement is the one I'm having trouble with:
Here is a snapshot of the pivot table:
Line Director (All)
Count of Issue Site = Column Label / Filter
Month Albuquerque Boise Chennai Florence Gray Greensboro
The error line is in Bold Typeface, the rest of the code works well!
Any help on how I can update the column filter based on a value that is on another cell/sheet just like the page fields is what I'm looking for, and would be greatly appreciated!