AutoFilter.ShowAllData Method (Excel)

Displays all the data returned by the AutoFilter object.

Version Information

Version Added: Excel 2007

Syntax

expression .ShowAllData

expression A variable that represents an AutoFilter object.

See Also

Concepts

AutoFilter Object

AutoFilter Object Members