Share via


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.

See Also

Reference

AutoFilter Members

Microsoft.Office.Interop.Excel Namespace