View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tim Zych Tim Zych is offline
external usenet poster
 
Posts: 389
Default Excel Macro Using "Like" comparison

I don't follow your example, but in general I like converting to upper case
for case insensitive comparison.

If UCase(s1) Like UCase(s2) Then...


--
Tim Zych
http://www.higherdata.com
Workbook Compare - Excel data comparison utility
Free and Pro versions


"jswalsh33" wrote in message
...
I have found it convenient to use a macro code such as - If Cells(x, 3)
Like
SS = True Then Check = "True"- where SS is - SS = Range("E12") & "*".

I find that this comparison is case sensitive, which is inconvenient for
my
purposes. Is there a way of making this process insensitive to case with
this
macro code or some other code?

Jim Walsh