_Worksheet.ShowAllData Method
Makes all rows of the currently filtered list visible. If AutoFilter is in use, this method changes the arrows to "All."
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Sub ShowAllData
'Usage
Dim instance As _Worksheet
instance.ShowAllData()
void ShowAllData()