VBA For.. Next.. Loop Equivalent of "Continue For"

[Papa_Don]

Group,

I have a very simple For/Next Loop that simply says:

For rowNo = 2 To 2000
Go do some stuff
Next rowNo

However I need to insert a "Goto the next iteration of this loop" in a IF statement. However I'm struggling to find the correct syntax to make this happen. Can you help?

I need to say:

For rowNo = 2 To 2000
Go do some stuff
If rmRev = 0
Continue For ' Go to the next iteration of the For Loop
End If
Next rowNo

Can you tell me the correct syntax to do this?

Thanks for your help.

Don

​

 

[grawls44]

Hi Don

try this

For rowNo= 2 to 2000
    if rmRev = 0 then
        Go do some stuff
            else
               Go do something else
           end if
  next rowNo

Greg

 

[Jonmo1]

Try reversing the logic of your if.
Instead of saying 'Don't do this or that if rmRev=0
Do it like "do this or that if rmRev DOES NOT = 0

For rowNo = 2 To 2000
    If rmRev <> 0
         Go do some stuff
    End If
Next rowNo