Need help identifying a value range for ending a Loop Until

**ExcelTab** · 06-05-2013, 05:06 AM

Dear erik1,

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

In your case, your code would be:

Loop Until Range("L433").Value > -0.0055 Or Range("L433").Value < 0.0055

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

Have fun !

**erik1** · 06-05-2013, 03:54 PM

Thanks, ExcelTab. I replaced my old Loop Until line with your suggested code and it works, but to get what I specifically was looking for I had to replace your "Or" with an "And." I'm a bit embarrassed because I could've sworn I had tried that already, but there you go. In the meantime I found an alternate fix by using an "IF-AND" [=IF(AND(L433>-0.0055,M433< 0.0055), "Yes","No"] to define a single condition to use as a stop for the macro, but yours of course is the more elegant solution, and I'll switch to that. One additional question: If I wanted to use an "And" along with an "Or" in the same Loop Until, for example--

Loop Until Range("L433").Value > -0.0055 And Range("L433").Value < 0.0055 Or Range("K433").Value>-0.055 And Range("K433").Value < 0.055

would I have to use some parentheses or brackets or something around the 2nd half or the statement? Thanks in advance.

**erik1** · 06-05-2013, 03:56 PM

Oops, in the last post I meant:

"In the meantime I found an alternate fix by using an "IF-AND" [=IF(AND(L433>-0.0055,L433< 0.0055), "Yes","No"] to define a single condition to use as a stop for the macro..."