Spread WinForms 15
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / IAutoFilterOwner Interface / CreateAutoFilter Method
An integer value indicates the top row index of cell range.
An integer value indicates the left column index of cell range.
An integer value indicates the bottom row index of cell range.
An integer value indicates the right column index of cell range.


In This Topic
CreateAutoFilter Method (IAutoFilterOwner)
In This Topic
Creates the automatic filter.
Syntax
'Declaration
 
Function CreateAutoFilter( _
   ByVal worksheet As Worksheet, _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal row2 As Integer, _
   ByVal column2 As Integer _
) As AutoFilter
 
'Usage
 
Dim instance As IAutoFilterOwner
Dim worksheet As Worksheet
Dim row As Integer
Dim column As Integer
Dim row2 As Integer
Dim column2 As Integer
Dim value As AutoFilter
 
value = instance.CreateAutoFilter(worksheet, row, column, row2, column2)

Parameters

worksheet
row
An integer value indicates the top row index of cell range.
column
An integer value indicates the left column index of cell range.
row2
An integer value indicates the bottom row index of cell range.
column2
An integer value indicates the right column index of cell range.

Return Value

An AutoFilter object represents the created filter. null if the data is invalid.
See Also