Luke,

Value is the default property addressed when none is specified for range objects, so these two are
essentially identical,,though the first is the better programming practice:

If Cells(1, 1).Value = Cells(2, 1).Value Then
If Cells(1,1) = Cells(2,1) Then

HTH,
Bernie
MS Excel MVP


"Luke M" wrote in message
...
If Cells(1, 1).Value = Cells(2, 1).Value Then
MsgBox "They are equal"
End If
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Keith Norris" wrote:

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