VBA - Excel Filters - Show All Records

Post date: Jul 19, 2011 3:38:41 PM

The following Excel AutoFilter VBA code shows all records, if a filter has been applied.

Sub ShowAllRecords() If ActiveSheet.FilterMode Then ActiveSheet.ShowAllData End If End Sub