[SOLVED!] VBA Excel reset filters without removing them

VBA in Excel. You want to reset the filters without removing them from the spreadsheet. Just like clicking on the Select All.
If ActiveSheet.AutoFilterMode = True Then
ActiveSheet.AutoFilterMode = False
End If
Rows("1:1").Select
Selection.AutoFilter

Just a very important note: Selection.AutoFilter works as a switch. Call it twice.

Advertisements