Comparing String Values
 

You can make all string comparisons in a given module case insensitive by
adding:

Option Compare Text

at the top.

Otherwise you can use:

lcase(str1) = lcase(str2)

or

StrComp(str1,str1, vbTextCompare)

--
Jim Rech
Excel MVP
"Ben H" wrote in message
...
| Spot on, Gentlemen! Thanks!
|
| Now about the follow!
| Is there a way to make it to return true when comparing, "J45006" to
| "j45006"?
|
| Thanks!
|
|