then goto next

[clozed75]

Hi all, sorry for this very soft question..

assume a FOR..NEXT cycle with a nested IF ...THEN.

how can I go from the THEN statement directly to the NEXT (bypassing other lines) ?

is there anything like IF....THEN GOTO NEXT ??
currently I use a label before the next.. any other way?

thanks

Cloe

 

[Special-K99]

Post your code, its not clear what you want.

 

[Jon von der Heyden]

Something like:

Say you want to do something within a loop if a condition is met:

For i = 1 to 100
    If Cells(i,1).Value=100 Then
        'Then do something
    End If
Next i

To exclude:

For i = 1 to 100
    If [B]Not[/B] Cells(i,1).Value[B]=[/B]100 Then
        'Then do something
    End If
Next i

 

[Weaver]

If you nest your code properly, this might not be required

FOR....
IF condition is TRUE then
don't do anything
ELSE
do all that other stuff
END IF
NEXT...

 

[Jon von der Heyden]

If you nest your code properly, this might not be required

FOR....
IF condition is TRUE then
don't do anything
ELSE
do all that other stuff
END IF
NEXT...

Weaver, you can eliminate the Else statement as follows:

If [COLOR=DarkRed][B]Not [/B][/COLOR]condition is True Then
    'do all that other stuff
End If

 

[clozed75]

something like..

For Each cell In Range("xxx")


If xxxx = xxx And yyy= yyy Then
goto fine
else
(code)
end if
(code ..code)

fine:
next

 

[Norie]

Cloe

GoTo is available but it really should be avoided.

Using it and labels will probably make the code harder to understand and follow rather than the opposite.

There are plenty of other methods you could use, like the IF... that has already been suggested.

It really depends on what the code is meant to do.

As has been asked already, can you post some sample code?.

 

[Jon von der Heyden]

something like..

For Each cell In Range("xxx")


If xxxx = xxx And yyy= yyy Then
goto fine
else
(code)
end if
(code ..code)

fine:
next

Try;

For Each cell in Range("xxx")
    If [B]Not[/B] (xxx=xxx And yyy=yyy) Then
        (code)
    End If
Next cell