AutoFilter Property (IWorksheet)

Gets an IAutoFilter object if filtering is on.

Syntax

Visual Basic
C#

'Declaration
 
ReadOnly Property AutoFilter As IAutoFilter

'Usage
 
Dim instance As IWorksheet
Dim value As IAutoFilter
 
value = instance.AutoFilter

IAutoFilter AutoFilter {get;}

Property Value

An IAutoFilter object represents the filter of this IWorksheet object.

Remarks

The property returns Nothing if filtering is off.

To create an IAutoFilter object for a worksheet, you must turn auto-filtering on for a range on the worksheet either manually or using the IRange.AutoFilter method of the IRange object.

Reference

IWorksheet Interface
IWorksheet Members

Product Support Forum | Print this page