ShowAllData Method

         Example         Applies To

Makes all filtered rows visible on the specified worksheet and sets all filters to Show All.

Syntax

expression.ShowAllData

expression   An expression that returns a Worksheet object.