Showing posts with label Macro to remove auto-filter mode. Show all posts
Showing posts with label Macro to remove auto-filter mode. Show all posts

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
at No comments:
Labels:
Subscribe to: Posts (Atom)

Import data from SQL

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

  • Export Range in Json Format
    Macro to Export Range in Json Format Option Explicit Sub export_in_json_format()     Dim fs As Object     Dim jsonfile     Dim rangetoex...
  • Running SQL Queries within Excel Environment
    If you want to run SQL queries within Excel environment without  connecting to any database, you can do it with creating the ADODB   conn...