If Cells(i, 2).Value = "n" Then
If Right(Cells(i, 1).Value, 2) = "sh" Or "ch" Then 'TYPE MISMATCH?
Cells(i, 3).Value = Cells(i, 1).Value & "es"
It shows an error message of "Type Mismatch" could you help me what am i doing wrong? Have a nice day!
If Right(Cells(i, 1).Value, 2) = "sh" Or "ch" Then 'TYPE MISMATCH?
Cells(i, 3).Value = Cells(i, 1).Value & "es"
It shows an error message of "Type Mismatch" could you help me what am i doing wrong? Have a nice day!