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 suitable. I only need the know the Column name , not the creterian, of each column in this autofilter if its filtered.
Thanks!
Leo Getz
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 suitable. I only need the know the Column name , not the creterian, of each column in this autofilter if its filtered.
Thanks!
Leo Getz