Solved: Problem writing formula

[Tuneman12]

I am trying to have a cell's formula be: the number on the left, times a number on another sheet, whose location depends on x

This is what I have, it doesn't work though



[vba]

Do while x < 10
.Offset(4, 4 + x).Formula = "=R[-1]C[-1] * Data Analysis!R3549!C"&(9 + x)
x = x + 1
Loop
[/vba]

[mdmackillop]

.Offset(4, 4 + x).FormulaR1C1 = "=R[-1]C[-1] * Data Analysis!R3549C" & (9 + x)