keyser,

ActiveCell.FormulaR1C1 = _
"=IF(RC[" & -res & "]<"""",RC[" & -res & "]&"" comments"","""")"

HTH,
Bernie
MS Excel MVP


wrote in message
oups.com...
I condensed it down to:

myRng(33, 2).FormulaR1C1 = "=SUM(R[-31]c:r[-1]c)"

Now I would like to add the formula : =IF(<Col1<"",<Col1&"
comments","") is an earlier column in the sheet.
I tried:


myRng(1, Res + 2).FormulaR1C1 = "=IF(C[-Res]<"""",C[-Res]&""
comments"","""") "

but this bombs. Can you tell me what the correct format of the formula
should be in this macro?

Thanks.