Looping till value is 1?

  • Thread starter Thread starter Jo
  • Start date Start date
J

Jo

How can I make this loop correct:


Dim SCell As Range

Do
Range("J24").Select
Calculate
Loop Until SCell.Value = 1

where SCell has a formula like this "if(c5>c11,1,0)"

Thanks,
Jo
 
Is that the entire code? It looks like it would loop infinitely unless
c5 or c11 change, somehow.
 
Is that the entire code? It looks like it would loop infinitely unless
c5 or c11 change, somehow.
Click to expand...

Yes, they do change as they have random number built in them......
 
Back
Top