adding data to new column
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.
|