ExcelBanter - cell reference in formula

Hi gogo
try
ActiveCell.FormulaR1C1 = "=sheet1!R[" & i & "]C"

HTH
Frank

gogo wrote:[i]
hi
here is what's troubles me. the code below doesn't work but it helps
you understand. i want that cell in (sheet2,B2) have a value of cell
in (sheet1,B2), cell in (sheet2,B3) have a value of cell in
(sheet1,B4) ... and so. the pattern is: columns are same but
rows in sheet2 are continues, and in sheet2 goes by even
numbers - 2,4,6,8... For a = 2 To 18
// a =number of row in sheet2 i = (a - 1) * 2
// i =even number sequence Range("B" & a).Select
ActiveCell.FormulaR1C1 = "=sheet1!RC" // here is question: how
to reference a variable index "i"
Next a

tnx in advance