Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro issue
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro issue
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro issue
Actually try putting 2 Value:
range("R" & i).value = range("M" & i).Value * 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro issue
sorry they do have value at the end its error miss match 13 if that rings a
bell... "Howard31" wrote: 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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro issue
Make sure that both range("M" & i).Value and range("L" & i).Value have
numeric values and note text values -- 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. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro issue
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro issue | Excel Discussion (Misc queries) | |||
Macro Issue | Excel Programming | |||
Macro Issue | Excel Programming | |||
Macro issue | Excel Programming | |||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming |