On a now closed thread, also dealing with a search on multiple criteria. mikerickson's posted (09-01-2011, 09:57 AM) code line as follows:

CSEFormula = ("Match(" & Chr(34) & sTerm1 & Chr(34) & "&CHAR(5)&" & Chr(34) & sTerm2 & Chr(34) & "," & .Range("C1:C100").Address(, , , True) & "&CHAR(5)&" & .Range("E1:E100").Address(, , , True) & ",0)")

I was able to get that code to work for me, but I don't understand what &CHAR(5)& does.

What is the purpose of that code snippet and why is it necessary in the formula?
Thanks.