TEST VBA: manual filter of a slicer is set

Frequent Visitor

Hi everyone ...


Is there a smart way to test by vba if the manual filter of a slicer (pivot table) is set?


E.g. I can clear the manual filter by vba, but I didn't find a way to simply test if it's set


The following picture of a slicer demonstrates my problem: 

- the manual filter of the slice is set


Thanks in advance!!!


Greetings Christoph


Set oSc = ActiveWorkbook.SlicerCaches(SlicerName)
With oSc

       end with

0 Replies