View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Hari Prasadh[_2_] Hari Prasadh[_2_] is offline
external usenet poster
 
Posts: 83
Default Jump to the next count in a FOR Loop

Hi Bernie,

Thnx a lot. Would use it for my purpose.

Your method of Skipout reminds me of On Error go to ...method, which I
learned recently.

Thanks a lot,
Hari
India

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...

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