View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
ashish128 ashish128 is offline
external usenet poster
 
Posts: 48
Default returning back to loop check condition without completing theloop

On Mar 18, 8:30*pm, Dave Peterson wrote:
Do While some_condition = TRUE

* * * '-----Some Code----

* * * *If this_condition = TRUE then
* * * * * *'do nothing
* * * *else
* * * * * *'some code here
* * * *End If

* * * *'no code here!!!!
loop





ashish128 wrote:

Hi All,


I apologise if this question has been posted before but to be true, I
could not find it.


I have a very little question. Please see below


Do While some_condition = TRUE


* * * '-----Some Code----


* * * *If this_condition = TRUE then


* * * * * * * ' Here I would like to send the execution back to "Do
While some_condition = TRUE"
* * * * * * * ' and bypass all succeeding lines of code


* * * *End If


* * * '-----Some Code----


loop


Kindly let me know if this is supported / possible in VBA.


Regards


Ashish


--

Dave Peterson- Hide quoted text -

- Show quoted text -


Dear Dave,

My question is to break the process flow in middle of a loop and
restart it from the loop condition checking.

Regards