IF statement and Right Help..

[SZBELL]

Im trying to change the code below to say If RIGHT ( Cell(i,6) , "9") = "Manhattan" ) Then. I cant seem to figure out the Right statement and wasn't able to find any other resources.. Also i want the code to loop until the last row, but i wont get greedy right away..


thanks.

Sub TestLooper()
Dim i As Integer
Dim LResult As String


For i = 1 To 4

    If Cells(i, 6).Value = "128 SPRING STREET MANHATTAN" Then
           
       Else
           Cells(i, 6).Interior.Color = vbYellow
           
           
           End If
           
           Next i
             
End Sub