ShowAllData Method Example
This example makes all data on Sheet1 visible. The example should be run on a worksheet that contains a list you filtered using the AutoFilter command.
Worksheets("Sheet1").ShowAllData