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