Autofilter
Post date: Feb 20, 2020 2:10:12 PM
Turn off Autofilter in VBA
Turn off Autofilter in VBA
Public Sub KillFilter()
Public Sub KillFilter()
If ActiveSheet.AutoFilterMode Then
If ActiveSheet.AutoFilterMode Then
ActiveSheet.AutoFilterMode = False
ActiveSheet.AutoFilterMode = False
End If
End If
End Sub
End Sub
Turn on Autofilter in VBA
Turn on Autofilter in VBA
Public Sub StartFilter()
Public Sub StartFilter()
If Not ActiveSheet.AutoFilterMode Then
If Not ActiveSheet.AutoFilterMode Then
ActiveSheet.Range("A1").AutoFilter
ActiveSheet.Range("A1").AutoFilter
End If
End If
End Sub
End Sub