Hi Rey,
When doing the VBA comparison, wrap both expressions in the UCase function. This will force the comparison to be done on the basis of the capitalized versions of the strings.
Code:
Sub Demo()
With ActiveSheet
If UCase(.Range("A1").Value) = UCase(.Range("B1").Value) Then
MsgBox "!"
End If
End With
End Sub
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Last edited by macropod; 05-03-2011 at 01:23 AM.
|