View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Jump to the next count in a FOR Loop


Hari,

Maybe something like:

For i = 1 To Alot
If Something Then GoTo SkipOut
'code here
If SomethingElse Then GoTo SkipOut
'or code here
If Not StillSomethingElse Then GoTo SkipOut
'other code here
SkipOut:
Next i


HTH,
Bernie
MS Excel MVP

"Hari Prasadh" wrote in message
...
Hi Leo,

Im sorry, I should have mentioned this in my original post.

Actually what u suggested Im already using. It's just that I wanted to

know
about other ways of dealing with it.

Especially what happens if I have many instances of -- 'Here I would like
to go to the next Count in I and skip the execution of code till ...--
within a single very big For Loop. Managing such a If else End If, becomes

a
little difficult. (Especially in the case when conditions are mutually
exclusive)

Thanks a lot,
Hari
India