Class AutoFilter (Excel VBA)

The class AutoFilter represents autofiltering for the specified worksheet.

ApplyFilter

Applies the specified AutoFilter object.

FilterMode

Returns True if the worksheet is in the AutoFilter filter mode.

Filters

Returns a Filters collection that represents all the filters in an autofiltered range.

With Worksheets("Crew") 
 If .AutoFilterMode Then 
 With .AutoFilter.Filters(1) 
 If .On Then c1 = .Criteria1 
 End With 
 End If 
End With

Parent

Returns the parent object for the specified object. Read-only.

Range

Returns a Range object that represents the range to which the specified AutoFilter applies.

rAddress = Worksheets("Crew").AutoFilter.Range.Address

ShowAllData

Displays all the data returned by the AutoFilter object.

Sort

Gets the sort column or columns, and sort order for the AutoFilter collection.