excel vba‎ > ‎

VBA - Excel Filters - Turn Off Excel AutoFilter

posted Jul 19, 2011, 8:40 AM by Roberto Felicini

Use the following Excel AutoFilter VBA code to turn off an Excel AutoFilter, if one exists

Sub TurnFilterOff()
'removes AutoFilter if one exists
  Worksheets("Data").AutoFilterMode = False
End Sub     
Comments