Worksheet.ShowAllData Method

Syntax

expression.ShowAllData

expression A variable that represents a Worksheet object.

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.

Visual Basic for Applications
`Worksheets("Sheet1").ShowAllData`

Display all records in a table? show show all data Show All Data Method Show all rows in a filtered list? ShowAll showalldata ShowAllData Method ShowAllData?

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

See also: