Nov 15 2021 01:45 AM
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
.ClearManualFilter
end with