This documentation is archived and is not being maintained.

Filter Interface

Represents a filter for a single column. The Filter object is a member of the Filters collection. The Filters collection contains all the filters in an autofiltered range.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

[InterfaceTypeAttribute()]
[GuidAttribute("00024434-0000-0000-C000-000000000046")]
public interface Filter

Use Filters(index), where index is the filter title or index number, to return a single Filter object.

Note that all the properties of the Filter object are read-only. To set these properties, apply autofiltering manually or using the AutoFilter method of the Range object.

Show: