Pivot Tables Using VBA

[mic_bo]

Hey guys!

I need help with regards to applying filters to a pivot table with VBA.

My code works fine when the applied filters are available in the pivot table. However, my code stops whenever an applied filter is not found.
For that reason, I was thinking of using a loop that would continue to next filter on error... but I don't know how to code it or even if that would work.

Here is my code below that applies my filters to the pivot table:

The code stops working when either today's date or tomorrow's date is not available as a filter.

Help please

[judgeh59]

untested - maybe try putting in something like this

Please Login or Register  to view this content.

[mic_bo]

untested - maybe try putting in something like this

Please Login or Register  to view this content.

*Yes this helped thank you

[judgeh59]

Glad this helped....major note though....turning on "On Error" can mask real errors, so use it carefully...

[judgeh59]

If this has been completed to your satisfaction, please set the thread to Solved...If you feel I deserve an increase in my reputation, feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be me...just a thought...