Pages

Saturday, September 17, 2011

Macro to remove auto-filter mode


If you want to check and remove if auto filter is applied on the sheet or not . Try this Code


Sub Remove_autofilter_if_applied()
    If Sheets("sheet1").AutoFilterMode = True Then
        Sheets("sheet1").AutoFilterMode = False
    End If
End Sub

No comments:

Post a Comment