Hi
Does anyone know how to write this code correctly in Excel
VBA:

Number=15
This will work:
ActiveCell.FormulaR1C1 = "=15*R[-2]C"

but how to make this work:
ActiveCell.FormulaR1C1 = "=Val(Number)*R[-2]C"
I have tried with & and " and I can not find a way to do it
Regards Leif

For E-mail: Substitute lablab with lab.