Highlight Non-indentical Text

[Barklie]

Hi,

I have a datasheet with product codes and product names. I'm trying to create a macro that highlights any instance when two rows have the same product code but different product names. I have a formula which isn't working and I suspect it's because I'm using the <> which I presume is designed for numbers rather than strings.

Here is my code

Sub product_code()
     If Range("U" & i) = Range("U" & i + 1) And Range("V" & i) <> Range("V" & i + 1) Then
        Range("A" & i & ":AD" & i).Interior.ColorIndex = 3
    End If
    If Range("U" & i) = Range("U" & i - 1) And Range("V" & i) <> Range("V" & i - 1) Then
        Range("A" & i & ":AD" & i).Interior.ColorIndex = 3
    End If
End Sub

Is there anyway for VBA to identify if the text within two cells is not the same? Thanks!

 

[Andrew Poulsom]

The <> operator works with strings as well as numbers, so that's not the cause of your problem.

 

[Barklie]

I'm in idiot, I forgot my For Next code. How do I delete this?

 

[Andrew Poulsom]

You can't delete your thread, sorry.