This is a problem I still haven't managed to get my head round in Excel VBA. I want to multiply a variable (intLatest) by the value in a cell (10th column). However, this formula always returns an error.
Range("L2:L" & Cells(Rows.Count, 1).End(xlUp).Row).FormulaR1C1 = "=IFERROR(SUM(RC11-(RC10*intLatest)),"""")"
Any ideas ?
Thanks in anticipation