Dim Str

Str="guangdong province"

With ActiveWorkbook. SlicerCaches (" slicer _ province ")

For Each Item In the SlicerItems

If the Item. The Caption=Str Then

Item. The Selected=True

The Else

Item. The Selected=False

End the If

Next

End With

CodePudding user response:

How can you jump over a false value option quick slicer?