excel vba‎ > ‎

VBA - Excel Filters - Show All Records

posted Jul 19, 2011, 8:38 AM by Roberto Felicini
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
Comments