Worksheet Function Right syntax help

[DougStroud]

Need help w/ this line:

If Cells(i, "M") = "Wheel" And Cells(i, "N").Value > 0 And Cells(Right(i, "N", 2) <> "mm") Then

The last bit- Cells(Right(i,"N", 2) is not proper.

Trying to do this in code:
=IF(RIGHT(N33,2)<>"mm",N33 & "mm")

thanks,

ds

 

[DougStroud]

Vog-
Column M is the size, numerical values; 150, 151, 152..... 170

 

[BrianB]

'Just change the code so it converts to upper case before check
'UCase (Right(Cells(i, "M").Value, 2)) <> "CM"
'- partial code
For i = 4 To LRow
If Cells(i, "F").Text = "SNOW" And Cells(i, "G").Text Like "BOARD*" _
And Cells(i, "M").Value > 0 And UCase(Right(Cells(i, "M").Value, 2)) <> "CM" Then
Cells(i, "M").Value = Cells(i, "M").Value & "cm"
End If
Next i