I copied much of the following code, which determines if a filter is used, and it works! But I just can't figure out what the two statements pointed out by arrows do.
In column L row 10 I have
In a module there is:
Code
Private Function FindFilterOn(ColRow As Range) As String
Dim Symbol As String
Application.Volatile
1-> With ColRow.Parent.AutoFilter
2-> With .Filters(ColRow.Column - .Range.Column + 1)
If .On Then
Symbol = String(15, ">")
End If
End With
End With
FindFilterOn = Symbol
End Function
Display More
Please someone be so kind to explain to me in simple words the two statements. I'm a beginner. Thank You!!