Thread: macro issue
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tim Zych Tim Zych is offline
external usenet poster
 
Posts: 389
Default macro issue

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.