View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Drenker Steve Drenker is offline
external usenet poster
 
Posts: 1
Default Incrementing Do/Loop, For/Next and For/Each

I've got several loops where I discover midway through the loop that I don't
want to process the remaining commands before the "Loop" or "Next" at the
end of the loop. I DO NOT want to exit the loop -- just increment the
counter and process the next loop for next incremented variable.

I know that variables such as "i" in For i = 1 to 100 can be incremented
mid-loop, but this is not advisable.

Is there a way to skip to the bottom of a loop without using a GoTo
statement? Or is that the only way?

The Exit For command is no good because I want to continue processing the
remaining elements, not end the loop.

TIA
Steve

Sdrenker <is at pacbell <with a dot net