ShowAll Property Example
This example clears the AutoFilter criteria for column 1 on the active worksheet and then reapplies the AutoFilter to the worksheet.
Set af = Spreadsheet1.ActiveSheet.AutoFilter af.Filters(1).Criteria.ShowAll = True af.Apply