Comparing Text Contents of Cells
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
|