VBA to control filter date in multiple pivot tables

Hi Harvey

Note the reason why i said it was plausible not definite
i created that sample in order to show it how it was plausible
without something to work on its impossible to tell as VBA pivot tables is finicky

Breaking down what my code does
there is a loop that loops every pivot table
within that loop another loop that goes thru all the pivot table field
checks the filter value to see if pivot table field exist in the pivot table
if it doesn't exist...hide that value
goes on hiding all lines and if it reaches the last line and doesnt find anything....clears all filters (this is what i am talking about in the 2nd post)

anyway i digress,
what i do mean to say is that this code is tailor made specific
you cant just plonk it in anywhere and hope it works

so unless you have a example sheet i can work with....i wouldn't know how to tell you know to fix it

ie
Attach a sample workbook. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic

i stress the bold bit