VBA - Excel Filters - Turn On Excel AutoFilter

Post date: Jul 19, 2011 3:40:16 PM

Use the following Excel AutoFilter VBA code to turn on an Excel AutoFilter, if none exists

Sub TurnAutoFilterOn() 'check for filter, turn on if none exists If Not ActiveSheet.AutoFilterMode Then ActiveSheet.Range("A1").AutoFilter End If End Sub