Please tell me how to compare the contents of cells that contain text. If I
try to compare a cell that contains two identical strings, they never equal
each other. For example, if I try a statement similiar to the following:

If Cells(1,1) = Cells(2,1) Then
msgbox "They are equal"
End If

I have never been able to get this to result in a true condition meaning
They are equal is never shown in a messagebox when the two cells contain for
example EQUAL. I have also tried using the range object with no success. I
know this must be able to be done but I must not be using the correct syntax.

Please reply with the correct syntax and an example.

Thank you very much in advance!




--
Thank You,
Keith