Turn off Autofilter in VBA
The following code example turns Off autofilter, checking first that it’s not Off already.
Public Sub KillFilter() If ActiveSheet.AutoFilterMode Then ActiveSheet.AutoFilterMode = False End If End Sub
Turn on Autofilter in VBA
The following code example turns on autofilter, checking first that it’s not on already.
Public Sub StartFilter() If Not ActiveSheet.AutoFilterMode Then ActiveSheet.Range("A1").AutoFilter End If End Sub
VBA Coding Made Easy
Stop searching for VBA code online. Learn more about AutoMacro – A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!