P
Paul
Hi,
Do While Range("b11").Value > 0
Range("e15").Value = Range("e15").Value + Range("c15").Value
Range("e16").Value = Range("e16").Value + Range("c16").Value
Range("e17").Value = Range("e17").Value + Range("c17").Value
.........>>>
Range("e40").Value = Range("e40").Value + Range("c40").Value
Range("b11").Value = Range("b11").Value - 1
End
Loop
Any help appreciated. I'm trying to get a spreadsheet to check a list
of values if a condition is met. For example, B11 = 40 in this
instance. While this works as is, i would like to clean it up by
perhaps having a single line formula that would increment the row
values as it goes through the loop. along the lines of:
Range("b12").Value = "55"
Do While Range("b11").Value > 0
Range("b12").Value = Range("b12").Value - Range("b11").Value
Range("e[B11]").Value = Range("e[B11]").Value +
Range("c[B11]").").Value
Range("b11").Value = Range("b11").Value - 1
End
Loop
Thanks
Paul
Do While Range("b11").Value > 0
Range("e15").Value = Range("e15").Value + Range("c15").Value
Range("e16").Value = Range("e16").Value + Range("c16").Value
Range("e17").Value = Range("e17").Value + Range("c17").Value
.........>>>
Range("e40").Value = Range("e40").Value + Range("c40").Value
Range("b11").Value = Range("b11").Value - 1
End
Loop
Any help appreciated. I'm trying to get a spreadsheet to check a list
of values if a condition is met. For example, B11 = 40 in this
instance. While this works as is, i would like to clean it up by
perhaps having a single line formula that would increment the row
values as it goes through the loop. along the lines of:
Range("b12").Value = "55"
Do While Range("b11").Value > 0
Range("b12").Value = Range("b12").Value - Range("b11").Value
Range("e[B11]").Value = Range("e[B11]").Value +
Range("c[B11]").").Value
Range("b11").Value = Range("b11").Value - 1
End
Loop
Thanks
Paul