Deal With Recursive (Endless Loop)

Hi all,

I have a VBA code to find largest value according to the capacity comparison. But if the result of comparison does not get "true", I have to stop the for loop of "k"
and make it start at the beginning of for loop of j.

Please Login or Register  to view this content.

If I call another macro as a result of false, then I have recursive VBA.

Please Login or Register  to view this content.

What should I do to deal with this problem?

Thanks in advance,
Oxco

Yes, but it does not work! =(

There are a couple of things I don't follow.

The blue code below doesn't change any values for each j loop, so nothing changes in the k loop. So if you were to exit k and reset to j=2, what would be different?. You don't use the value of j anywhere within its loop.

Also, the red code doesn't seem correct. k = (Row - 7 + a) evaluates to True or False which is a 1 or 0. Is that what you want?

I can't tell you what to fix because I don't follow what it is suppose to do?

Please Login or Register  to view this content.