Need help identifying a value range for ending a Loop Until

Hi. I have virtually no programming experience. I used the Macro Recorder to produce this code to generate a column of random numbers and then sort several columns of data by those numbers, effectively randomizing them. I poked around some discussion boards and was able to learn how to set up a rudimentary Do… Loop Until so the macro will run until a cell auto-populated by a selection of the data being randomized reaches a criterion value.

The macro does run OK, but my problem is I need to be able to define a range this is at the same time both above one value and below another value (e.g., both > -0.0055 and < 0.0055), and right now I can only do one or the other (e.g., either > -0.0055 or < 0.0055). I’d also like to know how to define a loop stopping criterion based on values from two different cells, or on ranges from two different cells.

This should be an easy fix for someone with some experience with VBA. Thanks in advance. Here is my code:

Please Login or Register  to view this content.

Dear erik1,

You can add "OR" and "AND" statements in a Loop Until statement.

In your case, your code would be:

Please Login or Register  to view this content.

You can add any criteria (other ranges, other values, variables, any conditions, basically)

Have fun !

Hello erik1,

I will try to explain you the logic of the position of the AND / OR statements:

First case:

Please Login or Register  to view this content.

This will run until either:

• A And B are both true
• C is true

Second case:

Please Login or Register  to view this content.

This will run until either:

• A And B are both true
• A And C are both true

Hope this helps.

Have fun!