Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub InvertFilters()
- Dim rng_cell As Range
- For Each rng_cell In Range("myActualFilter")
- rng_cell.Value = Not rng_cell.Value
- Next rng_cell
- Range("myCheckBoxAll").Value = _
- Application.WorksheetFunction.And(Range("myActualFilter").Value)
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement