_Worksheet.AutoFilter Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public:
 property Microsoft::Office::Interop::Excel::AutoFilter ^ AutoFilter { Microsoft::Office::Interop::Excel::AutoFilter ^ get(); };

public Microsoft.Office.Interop.Excel.AutoFilter AutoFilter { get; }

Public ReadOnly Property AutoFilter As AutoFilter

Property Value

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(Object, Object, XlAutoFilterOperator, Object, Object) method of the Range object.

Applies to