how does thi code do what it does?! If Not Intersect.....

I know what the result of this code is but I don't understand the terms/syntax. Can someone, explain in layman's terms what it's doing please?

If .AutoFilterMode = True Then
        If Not Intersect(.AutoFilter.Range, .Range("F18")) Is Nothing Then
            .Range("$A$18:$BQ$1000").AutoFilter Field:=.Range("F:F").Column
        End If
    End If
End With

Thanks
MissDB

In effect, it means if you multiply two negative numbers, you get a positive answer. So, "Not" and "Nothing" could be interpreted as "Match". If the two range meet(Intersect), do the lines after the meet.

Sorry I still don't understand. I know that this code looks to see if there is a filter on range F18 and then clears it but how is it actually doing this? What does the Intersect bit do?

Intersect can be looked at like a crossroads on the road. If not intersect is nothing translates into, if one car driving across the crossroads doesn't crash into the car driving up or down the crossroads, then do nothing. So if the Cell F8 is in the autofilter range and you enter something in it, the cars crashed, so do something. If something is entered in another cell, the cars didn't crash, so do nothing.
Does that help?

You have two ranges(or cells), that is AutoFilter.Range and Range("F18"). When these two lines( Ranges) intersect (meet) then do the rest of the code. If they do not intersect, nothing will happen and the code jumps to the next if. I hope it is now clear.

So, if there is a filter applied to F18 it will un-filter, if not it will leave as is?

Thank you all very much. Very helpful. I think I've got it now! I love this site :-)