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