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
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