PDA

View Full Version : Solved: Problem writing formula



Tuneman12
03-25-2009, 01:08 PM
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





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

mdmackillop
03-25-2009, 01:32 PM
.Offset(4, 4 + x).FormulaR1C1 = "=R[-1]C[-1] * Data Analysis!R3549C" & (9 + x)