I am trying to to change the the filter on a Pivot Table use the below VBA. I think the issue is with connecting to an Olap cube pivot table and not a normal pivot table. Highlighted in red is where the debug throws the error:
"Run-time error '1004':
Unable to set the CurrentPage property...
Hi, I'm a little bit stuck with a load of macros that generate pivot tables, i want to make it so i can make global changes easier.
I currently have about 50 macros similar to the one below and making a change in all of them is a little time consuming.
My idea was the split the macro up...