expression.ShowAll
expression Required. An expression that returns a Criteria object.
Example
This example clears the AutoFilter criteria for column 1 on the active worksheet and reapplies the AutoFilter to the worksheet.
Sub ReapplyAutoFilter()
Dim afAutoFilter
' Set a variable to the current filter settings.
Set afAutoFilter = Spreadsheet1.ActiveSheet.AutoFilter
' Show all records.
afAutoFilter.Filters(1).Criteria.ShowAll = True
' Reapply the filters.
afAutoFilter.Apply
End Sub