WorksheetBase.ShowAllData Method

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

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

Syntax

'Declaration
Public Sub ShowAllData
public void ShowAllData()

.NET Framework Security

See Also

Reference

WorksheetBase Class

Microsoft.Office.Tools.Excel Namespace