One way

If UCase(Range("c1")) = UCase(Range("c2")) Then MsgBox "ok"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ayo" wrote in message
...
if c1="INDIANAPOLIS" and c2="Indianapolis" why is the statement after the
if
statement never executed?
If c1.Value = c2.Value then
c1.Offset(0, 6) = c1.Offset(0, 6) + c2.Offset(0, 3)