I'm trying to filter 10 pivot tables at the same time so I can select the same week for all of them.

I have a combo box that I can select what week I want to view. I did it this way because I wanted it to be immediately selectable rather than a list via data validation where you have to click on the cell and then the drop down.

When I initially set this up I tried it with 1, 2, and 3 tables at a time and it worked fine but the more I added it stopped working. Unless I drop down the number of tables I'm filtering it simply doesn't work. That's why I'm so confused on this error because it only stops working with multiple tables even though the code doesn't change when I add or remove tables to filter. I get the error below that pop's up and when I look at the code it highlights "PF.CurrentPage = str" as the issue.

Run-time error '1004':
Application-defined or object-defined error

I tried various things but nothing has worked so far. Does anyone have an idea of how I could fix this? The code below represents one pivot table's filter adjustments, I have one of these for every table, and have a separate piece of code attached to the combo box that calls all of the tables to change. Is that the problem? I couldn't get it to work to just have one portion of code to update all of them. Open to suggestions.

Please Login or Register  to view this content.