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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What is wrong with this vba piece of code? 4
Looping till condition is satisfied? 3
Help with macro? 5
Simple VBA code questions 5
How to use ActiveCell to mean a particular cell? 3
How to make this macro stop? 5
Read in cell value and comment from 2 selected cells 3
Sum a range of cells based on relative position 3

Back
Top