View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default returning back to loop check condition without completing the loop

You didn't like Rick's reply?

ashish128 wrote:

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


--

Dave Peterson