How to Avoid Infinite Loop?

I'm writing a program that needs to perform a certain function with a "do until" loop, but if the task I want it to "do" is going to result in an infinite loop, I want the program to switch to a different "do until" loop. For example, I want it to perform task "x" and loop until y=0, but there will be some instances where the task in the initial loop will never cause y to equal 0, so if that is the case I want it to perform task "z" and loop until y = 0. The second loop will always eventually lead to y = 0, but how do I get the program to realize the initial loop is infinite/cannot be done if that is the case? I hope this isn't too vague...

Originally Posted by Norie

What is the function this program is meant to do?

I actually figured out what I needed to do, but the first function should only need to run 4 times at most so I just put "variable = variable + 1" in the "do" statement, then have it "loop until variable = 4". Thanks anyway!

Originally Posted by GC Excel

Hi,
One way to do it would be to put a counter in your first loop. If that counter reaches a determined value the change loop. There may be some other / better way to do it, but without having more details, it's difficult to say.

n = 0
Do Until Y = 0
   Perform_Task_X
   n = n + 1
   If n > 10000 Then GoTo Z:
Loop

Z:
Do Until Y = 0
   Perform_other_task
Loop

Just saw this. Thanks!