ClearFilters Method (WorksheetTable)

Clears all filters from the columns in the table.

Syntax

Visual Basic

'Declaration
 
Public Sub ClearFilters() 

C#

public void ClearFilters()

Remarks

If any filters are present and removed when this is called, all hidden rows in the data area of the table will be unhidden.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2