GetAutoFilter Method

In This Topic

Get the AutoFilter information for the specified sheet

Syntax

'Declaration
 
Function GetAutoFilter( _
   ByVal sheet As Short _
) As IExcelAutoFilter

'Usage
 
Dim instance As IExcelWriter
Dim sheet As Short
Dim value As IExcelAutoFilter
 
value = instance.GetAutoFilter(sheet)

IExcelAutoFilter GetAutoFilter( 
   short sheet
)

sheet: the zero based sheet index used to locate the IExcelWorksheet instance

An IExcelAutoFilter instance represent the AutoFilter settings for the specified sheet.