ShowAllData Method
From Microsoft Office Web Components Visual Basic
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