I have a macro that enters a sum formula into a cell and copies the formula
to several columns. The formula works in the initial cell but is simply
duplicated in the other columns when I want it to copy the formula using
relative cell addresses. Here is the formula in the macro:

ActiveCell.FormulaR1C1 = "=Sum(FIRSTROW:LASTROW)"

The named ranges FIRSTROW and LASTROW have been correctly set previously in
the macro.

Does anyone have any ideas?

Thank you

Tim U