Applies To
Worksheet Object.
Description
Makes all rows visible for the currently filtered list. If the AutoFilter is in use, this method changes the arrows to "All".
Syntax
object.ShowAllData
object
Required. The Worksheet object.
See Also
AdvancedFilter Method, AutoFilter Method, FilterMode Property.
Example
This example makes all data on Sheet1 visible. The example should be run on a worksheet that contains a list that you filtered using the AutoFilter command on the Data menu.
Worksheets("Sheet1").ShowAllData