Filter interface

Office 2013 and later

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)

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

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: