VBA Loops and Pivot tables

first off im NO VBA pro.. im all self taught. mostly by reverse engineering recorded macros..

now the question... is it possible to use a loop to filter pivot tables?

current layout is:
i have aprox 10-15 charts..... these are all generated from pivot tables....

i am using an extended version of the following code to capture user input to filter the charts via filtering the pivot tables... but i have a feeling im doing it the "Long way" hence the quest for an easy loop...

Please Login or Register  to view this content.

it runs through the EXACT same sequence for each pivot table..... there has to be a faster way?

Please put code tags around your code so we can answer...

Originally Posted by romperstomper

Please put code tags around your code so we can answer...

sorry about that... was not familiar with the [code] tags.... it has been updated...

Are you doing the same things to every pivot table on the worksheet?

Yes they will all be filtered using the same input....

Then you can use a For Each loop:

Please Login or Register  to view this content.

ahhh... see i knew there was an easy loop in there!!! thank you... that beats having to copy and paste the same 10 lines of code and change the pivot table name... 15 times... considering i use this style for MANY files!

thank you so much!