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.