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