Tom Ogilvy Help Me...

[darno]

hI

IN THE FOLLOWING MACRO PART I NEED A LITTLE MORE HELP. SEE IF YOU CAN
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 formula
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 want
like this. what i am looking for is to keep the first range freeze
while the other moving. i.e., Sum($a$1:b84), but we do not know from
which cell the range shall start and end. Looking for a wayout.

Regards,

Darno

 

[Tom Ogilvy]

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

Would be my best guess at what you want.