Advertisement
Guest User

Untitled

a guest
Aug 30th, 2016
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. Sub InvertFilters()
  2. Dim rng_cell As Range
  3. For Each rng_cell In Range("myActualFilter")
  4. rng_cell.Value = Not rng_cell.Value
  5. Next rng_cell
  6. Range("myCheckBoxAll").Value = _
  7. Application.WorksheetFunction.And(Range("myActualFilter").Value)
  8. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement