Clear Method (AutoFilter)

In This Topic

Clears the filter and sort state at the specified column for the current object.

Syntax

Visual Basic
C#

'Declaration
 
Public Sub Clear( _
   ByVal column As Integer, _
   Optional ByVal removing As Boolean, _
   Optional ByVal notify As Boolean, _
   Optional ByVal fireEvent As Boolean _
)

'Usage
 
Dim instance As AutoFilter
Dim column As Integer
Dim removing As Boolean
Dim notify As Boolean
Dim fireEvent As Boolean
 
instance.Clear(column, removing, notify, fireEvent)

public void Clear( 
   int column,
   bool removing,
   bool notify,
   bool fireEvent
)

Parameters

column: An integer value indicates the column index.
removing: if set to true, the current active filter will be removed; otherwise, it'll be set as inactive.
notify
fireEvent: if set to true, the control will fire event.

Reference

AutoFilter Class
AutoFilter Members