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)

Syntax

'Declaration
<InterfaceTypeAttribute()> _
<GuidAttribute("00024434-0000-0000-C000-000000000046")> _
Public Interface Filter
'Usage
Dim instance As Filter
[InterfaceTypeAttribute()]
[GuidAttribute("00024434-0000-0000-C000-000000000046")]
public interface Filter

Remarks

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.

See Also

Reference

Filter Members

Microsoft.Office.Interop.Excel Namespace