ShowAllData Method

See Also         Example         Applies To

Makes all rows of the currently filtered list visible. If AutoFilter is in use, this method changes the arrows to "All."

Syntax

expression.ShowAllData

expression   Required. An expression that returns a Worksheet object.