Hi everyone,
I have the following macro (piece of it); which works very well:
'We loop from Lastrow to Firstrow (bottom to top)
For Lrow = Lastrow To Firstrow Step -1
'We check the values in the A column in this example
With .Cells(Lrow, "Q")
If Not IsError(.Value) Then
If IsNumeric(.Value) = True Then
If .Value >= 100 Then
.Value = (.Value + 7) * 1.3
End If
End If
'Checks if value in row Q is 100 or more and applies formula
End If
End With
Next Lrow
Now I would like to change it in a way that it does the following:
If the value in column A is "NAME1", then the value in column B will multiply by 1.5
Haven't a clue where to begin, can anyone help me please?
Thanks in advance,
DMR
Bookmarks