Skip to content

Instantly share code, notes, and snippets.

@Se7enSquared

Se7enSquared/clearallfilters.vbs

Created June 9, 2021 20:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Se7enSquared/f7815e0118adbaec71786ff65b579ac0 to your computer and use it in GitHub Desktop.
Save Se7enSquared/f7815e0118adbaec71786ff65b579ac0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
clearallfilters.vbs
Private Sub ClearAllFilters()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.ShowAllData
Next ws
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment