MrExcel Publishing
Your One Stop for Excel Tips & Solutions

testing strings with ignore case

Posted by Damien on July 04, 2001 4:57 PM

anyone know how to test two strings against each other
but to ignore the case of either ??

Posted by Ivan F Moala on July 04, 2001 7:15 PM

@ beginng of your module decalrations put in
Oprtion Compare Text

OR just

If UC(text1) = UC(text2) Then