Nov 15 2021
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!!!
Set oSc = ActiveWorkbook.SlicerCaches(SlicerName)With oSc .ClearManualFilter