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.