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

slicer.jpg

Thanks in advance!!!

 

Greetings Christoph

 

Set oSc = ActiveWorkbook.SlicerCaches(SlicerName)
With oSc
   .ClearManualFilter

       end with

0 Replies