ShowAll Property

Microsoft Office Web Components Object Model

ShowAll Property

       

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