vba check if filter is on and turn off
Public Sub ClearFilter() If ActiveSheet.FilterMode = True Then ActiveSheet.ShowAllData End If End Sub
Source: www.automateexcel.com
Public Sub ClearFilter() If ActiveSheet.FilterMode = True Then ActiveSheet.ShowAllData End If End Sub