Version

ReapplyFilters Method (WorksheetFilterSettings)

Re-filters all data cells in the filter region based on the applied filters.
Syntax
'Declaration
 
Public Sub ReapplyFilters() 
public void ReapplyFilters()
Remarks

Filters are not constantly evaluated as data within the region changes. Filters are applied to the region only when they are added or removed or when the ReapplyFilters method is called.

If no filters are applied this method will not do anything to the data.

Note: When the filters are reevaluated, the rows of any cells which don't meet the filter criteria of their column will be hidden. When a row is filtered out, the entire row is hidden from the worksheet, so any data outside the table but in the same row will also be hidden.

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

See Also