How to make a graceful exit from FOR TO Statement with nested IF THEN

[Granite-Granny]

I have the following code and I keep getting an error on the if then exit

Please Login or Register  to view this content.

I get a "complie error: Next without For" at the "Else Next i" line.

I don't really understand why? The syntax seems like it should work.

Anyway I fixed it with:

Please Login or Register  to view this content.

Is there a more graceful way to exit this loop? What I'm trying to say is that if Z = 0 start at the next i.


Thanks,

GG

[ragulduy]

Please Login or Register  to view this content.

I suppose, I would normally try and define where variable1 becomes 0 and set that to the value of Z before entering the loop though, makes it easier to follow/debug the code in the long run.

Edit:

Or use a do.. until construct like Miraun suggests.

[Miraun]

Excel really hates variables being messed when using for i = x to y commands. I could try to go into a technical reason... but the fact remains, I haven't had much luck altering i,x,y variables within the for/next commands.

If you're going to be manipulating the variables on the fly with subsequent subroutines, you're better off using a Do until i > y / loop command. It gives you more control over the variables to be dynamically altered based on subsequent changes.

[Granite-Granny]

The "Exit For" command is what I was looking for. Much more graceful than altering the variables on the fly.

Thanks for the advice.


GG