vba to change date range on multiple pivot tables

[jjin]

Hi guys,

I have been trying to find a way to autofiltering date range using vba code and luckly have found the following vba code which does exactly what i want to achive and it works fine.
Now, the problem that I have is that I have more than 1 pivot table in the worksheet and I would like the code to apply to all the pivot tables in the worksheet at the same time.

Can someone please amend the code below to achive this?

Much appreciated.

Kind regards, Jim

Please Login or Register  to view this content.

[FDibbins]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

http://www.excelforum.com/excel-prog...ot-tables.html