View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default continue statement in a loop

Dave:
That looks like some variation of C.


Original Post:
I have some code in Java I am trying to use in macro.


Many say Java looks a lot like C, so you are not alone in your assessment
<g

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
That looks like some variation of C.

You could just do:

dim i as long
dim SomeLength as long

somelength = 12 'whatever???

for i = 1 to somelength step 1
'do some stuff
if conditionstatement = true then
'do nothing
else
'do more stuff
end if
next i

(Just a guess, though. I don't speak the C.)

rozner wrote:

Hi,

I found the "continue" statement in VB documentation but I think it was
only for .NET, it doesn't seem to compile with Excel and VBA. Is there a
way to do this?

I have some code in Java I am trying to use in macro. I'm looking for
the Java equivalent of:

Code:
--------------------

for (int i=0; i<someLength; i++) {
// do some stuff

if (condition) {
continue;
}

// more stuff
}

--------------------

I haven't done VB in a while but I was thinking perhaps a goto
statement may work. Any suggestions on this? Thanks a lot

--
rozner
------------------------------------------------------------------------
rozner's Profile:

http://www.excelforum.com/member.php...o&userid=25794
View this thread:

http://www.excelforum.com/showthread...hreadid=391982

--

Dave Peterson