ShowAllData Method
The document is archived and information here might be outdated

ShowAllData Method

Office 2003

Makes all filtered rows visible on the specified worksheet and sets all filters to Show All.

expression.ShowAllData

expression    An expression that returns a Worksheet object.

Example

This example makes all filtered rows visible on the active worksheet and sets all filters to Show All.

Spreadsheet1.ActiveSheet.ShowAllData
		


Applies to | Worksheet Object


Show:
© 2016 Microsoft