How to move the sum formula

[Vishappu]

Hi,

I have to copy the sum formula from one column to the next
I used (the range of second coloumn)=range of first column.formula
The reason is I would like to roll forward the formula of month to
another month
Range(Cells(x, i + 2), Cells(y, i + 2))= Range(Cells(x, i), Cells(y,
i)).Formula
it works well except the sum formula cells.
the sum formulas inside is again referencing the old location.what
to do.Please help me out.
Thanks,
Santhosh

 

[Dave Peterson]

I think it depends on what formula is in the original cell.

Maybe...

Range(Cells(x, i + 2), Cells(y, i + 2)).formular1c1 _
= Range(Cells(x, i), Cells(y, i)).FormulaR1C1

If this doesn't help, you'll want to give the original formula and what you want
it to be.