Filter - which column is filtered?

[Gabriell]

Hi Everybody!

I have a excel table with 300+ columns and when I use a filter, it is very difficult to find later in which column the filter was applied.
Is there any formula that can identify the column where the filter is active?

Thank you in advance!
Gabor

 

[BSALV]

Is it posible in VBA to find out which column is filtered ?

Hi, I have a sheet with an autofilter applied. Is it possible to write to a cell which filters are applied? I already found out how to read the criterian : Dim f as filter For Each f In Me.AutoFilter.Filters If f.On Then MsgBox (f.Criteria1) End If next BUT, this is not...

www.mrexcel.com