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