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

Import data from SQL

Macro to import data from SQL using ADO connection string: Sub Import_data_from_SQL() ' Tools -> References -> Microsoft Active...