_Worksheet.AutoFilter Property

Returns an AutoFilter object if filtering is on. Returns Nothing if filtering is off. Read-only.

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

Syntax

'Declaration
ReadOnly Property AutoFilter As AutoFilter
    Get
'Usage
Dim instance As _Worksheet
Dim value As AutoFilter

value = instance.AutoFilter
AutoFilter AutoFilter { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.AutoFilter

Remarks

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

_Worksheet Interface

_Worksheet Members

Microsoft.Office.Interop.Excel Namespace