Use the StrComp function and specify text (case insensitive)
comparison:

If StrComp(Array1(0), Array2(0), vbTextCompare) = 0 Then
' equal
Else
' not equal
End If

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Mon, 25 May 2009 14:28:01 -0700, ExcelMonkey
wrote:

Can I compare two text strings and ignore case without using Regular
Expressions? Is there a regular VBA text function I can use?

If IgnoreCase(Array1(0)) = IgnoreCase(Array2(0)) then
'Do something

End if

Thanks

EM