Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
The clear (turn off) filter functionality from our move data based on dates subroutine
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'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