Looping till value is 1?

[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

 

[Dave O]

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

 

[Jo]

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

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