Skip to content

Instantly share code, notes, and snippets.

@danwagnerco

danwagnerco/clear_all_filters.vb

Created April 8, 2016 09:45
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 danwagnerco/1139d49f9bda3f1f36742efd23339a40 to your computer and use it in GitHub Desktop.
Save danwagnerco/1139d49f9bda3f1f36742efd23339a40 to your computer and use it in GitHub Desktop.
Download ZIP
The clear (turn off) filter functionality from our move data based on dates subroutine
Raw
clear_all_filters.vb
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'INPUT : Sheet, the Worksheet to turn off (clear) filters on
'DESCRIPTION : This sub clears (turns off) all filters on a Worksheet
'SPECIAL CASE: none
Public Sub ClearAllFilters(Sheet As Worksheet)
Sheet.AutoFilterMode = False
If Sheet.FilterMode = True Then
Sheet.ShowAllData
End If
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment