How To Remove Autofilter In Excel Vba

by

In Excel VBA, you can remove the autofilter from a worksheet using the AutoFilterMode property. Here’s how you can do it:

Sub RemoveAutoFilter()
    ' Disable autofilter if it is enabled
    If ActiveSheet.AutoFilterMode Then
        ActiveSheet.AutoFilterMode = False
    End If
End Sub

In the above example, we first check if the autofilter is enabled using the AutoFilterMode property of the ActiveSheet. If it is enabled, we then set the AutoFilterMode property to False to disable it.

Read more

Leave a comment