Thread: VBA continue
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob O`Bob Bob O`Bob is offline
external usenet poster
 
Posts: 16
Default VBA continue

kramer31 wrote:
Hi. I'm coming to VBA from a C/C++/Java background (and the syntax
makes me want to throw up, by the way--I plan to discontinue using VBA
as soon as possible--it would be nice if MS would give another language
option for scripting Office).

Anyway, can anyone tell me a VBA operator which jumps to the next
iteration of a loop similar to the C operator 'continue'?


GoTo
Honestly, it's likely the best - just add a label at the bottom of your loop.

Or you could define a block structure within the loop by using one of
the /other/ loop constructs, and then "Exit For" or "Exit Do" when you
need to. That's what I usually do.



Bob
--