Update formulas

[ten]

Hi,
I am trying to base my formula in my Excel based on some
Input I get from the user. This I save in iLastYear, and
have some labels (e.g. lBudgetLastYear etc) calculated
from this.

I tried using the formula under, but then Excel don't
recognize the variables I put in (e.g. iLastYear,
lBudgetLastYear etc)

ActiveCell.FormulaR1C1 = _
"=IF(RC[-8]=iLastYear,IF(RC[-7]
=1,lBudgetLastYear,lSum06LastYear),lSumSecondLastYear)"

How can I dynamically create an IF-sentence from VBA-code,
and put in one cell in Excel?

Thanks!

 

[Bob Phillips]

Ten,

Try this (untested I am afraid)


ActiveCell.FormulaR1C1 = _
"=IF(RC[-8]=" & iLastYear&"," _
"IF(RC[-7]=1," & lBudgetLastYear & "," & lSum06LastYear & ")," & _
lSumSecondLastYear & ")"