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:
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
Please someone be so kind to explain to me in simple words the two statements. I'm a beginner. Thank You!!