Is it possible to ask an autofilter what is current filtered criteriais?

[Chrisso]

Hi All

Is it possible to ask an autofilter what is current filtered criteria
is?

That is if a sheet is being filtered on column A for "foo" can I ask
the autofilter to return "foo"?

I want to ensure that I do not reapply a filter if it is already being
filtered.

Cheers for any thoughts,
Chrisso

 

[Chrisso]

Looked at Help!:

Sub Get_Filter_Criteria()
' the criteria I am interested in is in the 2nd column:
With ThisWorkbook.Sheets("Courses").AutoFilter.Filters(2)
Debug.Print Right(.Criteria1, Len(.Criteria1) - 1)
End With
End Sub