Try putting Value at the end:

range("R" & i).value = range("M" & i) * range("L" & i).Value

--
A. Ch. Eirinberg


"project manager" wrote:

i have a macro which throws up an error message when i run it, dont have the
whole code here but the problem line is:

else
range("R" & i).value = range("M" & i) * range("L" & i)
end

'i = target.row

i basically want the target row R to equal target row m times target row L.