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" & ")"


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