Clearing Specific Pivot Table Filters

Hi All

I am hoping someone can help

When I run the following piece of code, the sub mysteriously ends after completing the first 'ClearAllFilters' on the Case Type field

If I comment those 3 lines out the sub again clears the next filter (for Work Type), then stops. The remaining lines never get executed?

Am I doing something really silly?

Please Login or Register  to view this content.

PS there are several more filters on PivotTable1, but these are the only 4 I wish to clear at the press of a button

Any advice appreciated
All the best
V

Try this approach: (Untested)

Please Login or Register  to view this content.

Hi Maniacb

Thanks for the reply. That's certainly a much more succinct way to write it, but alas the problem persevered

So I tore down my workbook, every sheet module and item only to discover it was the 2 ActiveX command buttons that were causing the above script (and another one I found last night) to stop dead after updating pivottable1?

It's really weird but as soon as the ActiveX buttons were removed the scripts executed all the way through
Thank you though
All the best
V