AutoFilter Interface
Represents autofiltering for the specified worksheet.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
<GuidAttribute("00024432-0000-0000-C000-000000000046")> _
<InterfaceTypeAttribute()> _
Public Interface AutoFilter
'Usage
Dim instance As AutoFilter
[GuidAttribute("00024432-0000-0000-C000-000000000046")]
[InterfaceTypeAttribute()]
public interface AutoFilter
Remarks
Use the AutoFilter property to return the AutoFilter object. Use the Filters property to return a collection of individual column filters. Use the Range property to return the Range object that represents the entire filtered range.
To create an AutoFilter object for a worksheet, you must turn autofiltering on for a range on the worksheet either manually or using the AutoFilter method of the Range object.