ActiveCell.FormulaR1C1 = "='" & i & "'!R10C6"

"Mahi" wrote:

i cant get the following line working in my VBA programme
please hep me
activecell.formulaR1C1 = "='i'!R10C6"
where i is a variable referencing the sheet index number of all previous
sheets
thank you
Mahi