else
if isnumeric(range("m" & i).value) _
and isnumeric(range("L" & i).value) then
range("R" & i).value = range("M" & i).value * range("L" & i).value
else
range("R" & i) .value = "At least one is non-numeric!"
end if
end

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.

--

Dave Peterson