ShowAll Property

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