with a macro you have to use the row/column method of identifying a
cell in a formula - when i record =sum(blah:blah), this is what you get
in the VBA editor:

ActiveCell.FormulaR1C1 = "=SUM(R[-10]C:R[-2]C)"

(don't use this specific one - it doesn't sum as many rows as you
wanted).
susan