Help me Dr TOM...

[darno]

hI

IN THE FOLLOWING MACRO PART I NEED A LITTLE MORE HELP. SEE IF YOU CA
HELP?

frm = "=SUM(RC[-12]:R[83]C[-12])"
Set rng = rng(1, 1).Offset(-59, 0).Resize(84)
rng.FormulaR1C1 = frm
End If
End Sub

the problem is that as it copies the formula to 84 rows the sum formul
gets an increment in both starting range and end range i.e.
Sum(a1:b84), next line reads a2:b85, next reads a3:b86... i donot wan
like this. what i am looking for is to keep the first range freez
while the other moving. i.e., Sum($a$1:b84), but we do not know fro
which cell the range shall start and end. Looking for a wayout.

Regards,

Darn

 

[Tom Ogilvy]

frm = "=SUM(R1C[-12]:R84C[-12])"

Would be my best guess at what you want.