Worksheet.ShowAllData (Excel)

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

ActiveSheet.ShowAllData