Worksheet.ShowAllData Method
| Excel Developer Reference |
Makes all rows of the currently filtered list visible. If AutoFilter is in use, this method changes the arrows to "All."
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 |
|---|
|
See Also