I am trying to get this macro to multiply the number found in the 14th colomn by a fixed number (in this case 0.9) if the word renewal features in the 6th colomn (referred to as colomn "F" in the code)

here is what i have so far

Sub test()



Dim v As Variant, w As Variant
Dim a, i As Long, temp As String
Dim Lr As Long


Application.ScreenUpdating = False


For L = 190 To 17 Step -1 ' this fills in Renewal premium -10%
    w = Cells(L, "F").Value
    If w = "Renewal" Then
        Range(Cells(L, 7)).Value = Range(Cells(L, 14)).Value * 0.9
        
        End If
    Next

Application.ScreenUpdating = True
End Sub
I get a method range of object global failed error in the code in bold above.