sum dynamic named range

I have created named ranges using a For, Next loop.

Eg.
For j = 1 to 9
...
results - MVTOP1, MVTOP2...MVTOP9

Now I want to sum a range of cells using these named ranges. I cannot get the R1C1 formula to work! I have tried many many combinations - quotations in, out, moved.
CAn someone help?


This formula gives me the exact result I want:
ActiveCell.FormulaR1C1 = "=SUM(mvtop1:mvbottom1)"
But I want the mvtop and mcbottom to cycle through from 1 to 9.

This is what I currently am trying - without any luck:
'ActiveCell.FormulaR1C1 = "=SUM(" & "mvtop" & j" & ":" & "mvbottom" & j" & ")"


?????????????

You have extra quotes after each j - try it like this:

Please Login or Register  to view this content.

(I've also simplified it slightly)

In future, wrap code tags around any bits of VBA, like above.

Hope this helps.

Pete

THANK YOU so much!
That totally worked.
Christina