Makes all filtered rows visible on the specified worksheet and sets all filters to Show All.
expression.ShowAllData
expression An expression that returns a Worksheet object.
Example
This example makes all filtered rows visible on the active worksheet and sets all filters to Show All.
Spreadsheet1.ActiveSheet.ShowAllData