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!
|
|
|