Thread: Ignore Case without using Regular Expressions
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default Ignore Case without using Regular Expressions
If UCase(Array1(0)) = UCase(Array2(0)) then

or

If LCase(Array1(0)) = LCase(Array2(0)) then

Regards,
Bernd
Reply With QuoteReply With Quote