Thread: VBA continue
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 380
Default VBA continue

You just create a condition that only does the stuff if TRUE

For i = 1 To 100
If some_condition Then
'do your stuff
End If
Next i

so you always do the next iteration, but only do something before the
iteration is the condition is met.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"kramer31" wrote in message
ups.com...
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'?