Dear Coolboy
For x = 3 To (l_LastRow - 1) Step 1
If Target.Address = Cells(x, 4) Then
Cells(x, 5).Value = Cells(x, 5).Value * Cells(x, 4).Value
End If
Next x
In your above code, for starters,
Target.Address will return the absolute (by default) address of the
Target cell. From memory, the argument 'external' by default is False
giving you the cell address.
The 'Cells(x,4)' will return the value in the Cell(x,4). More than
likely these 2 values will always be different making the if condition
False. With you not having the Else clause, it doesn't do anything!
Hope this helps!
Best regards
Deepak Agarwal
--
agarwaldvk
------------------------------------------------------------------------
agarwaldvk's Profile:
http://www.excelforum.com/member.php...o&userid=11345
View this thread:
http://www.excelforum.com/showthread...hreadid=397926