ShowAll Property

  • Article

Clears AutoFilter criteria when set to True. Adding criteria sets this property to False. If there are no criteria and this property is set to False, no data will be shown. Read/write Boolean.

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

Applies to | Criteria Object

See Also | AutoFilter Method