range(CStr("R" & i)).value = range(CStr("M" & i)).Value * range(CStr("L" &
i)).Value
or my preference
Cells(i,"R").Value = Cells(i,"M").Value * Cells(i,"L").Value
--
Tim Zych
http://www.higherdata.com
Workbook Compare - Excel data comparison utility
Free and Pro versions
"project manager" wrote in
message ...
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.