Solved: Excel Macro Formula

[joms]

ActiveCell.FormulaR1C1 =SUM(RC[-9]:RC[-2])

hi guys, how to read this recorded formula by the macro. Thanks.

[joms]

ActiveCell.FormulaR1C1 =SUM(RC[-9]:RC[-2])

hi guys, how to read this recorded formula by the macro. Thanks.

never mind got it, correct me if i'm wrong:

RC[-9] = current row, 9 columns before the current column

RC[-2] = current row, 2 columns before the current column (is the last cell)

[mdmackillop]

Correct, but I would use the term "offset" as in the Excel function

[joms]

Thanks, Mdmackillop. :)