what about the other on<vbg

ActiveCell.FormulaR1C1 = "=MID(R2C5,Sheet1!R[" & your_variable &
"]C2,Sheet1!R[[" & your_variable & "]]C1)"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Frank Kabel" wrote in message
...
Hi
try
ActiveCell.FormulaR1C1 = "=MID(R2C5,Sheet1!R[" & your_variable &
"]C2,Sheet1!R[9]C1)"


--
Regards
Frank Kabel
Frankfurt, Germany
"GM" schrieb im Newsbeitrag
...
Boy am I stupid this formula

ActiveCell.FormulaR1C1 = "=MID(R2C5,Sheet1!R[9]
C2,Sheet1!R[9]C1)"

-----Original Message-----
Hi
which formula do you mean :-)

--
Regards
Frank Kabel
Frankfurt, Germany
"GM" schrieb im
Newsbeitrag
...
In this formula I would like [9] to become a variable
that
will loop/next from 10 to 63. There are some other
piecies
to this code, I just need to know how to make that 9 x.

TYIA
GM

.