Autofilter - how can you display selected filter in another

[grienerth]

Is there a way to display the filter to another cell when using autofilter ?

[Damon Ostrander]

Hi grienerth,

I'm not sure if this is what you want, but here is a user-defined function that returns the value (criteria1) of the n-th filter on a worksheet. So, for example, if you want the filter value of the first filter:

=FilterValue(1)

will display the value of the filter.

Function FilterVal(FilterNo As Integer) As String
Application.Volatile
If ActiveSheet.AutoFilter.Filters(FilterNo).On Then
FilterVal = ActiveSheet.AutoFilter.Filters(FilterNo).Criteria1
Else
FilterVal = "filter is off"
End If
End Function