Continue While

[bklabel1]

I noticed that there is not a Continue While or break in a While loop in VBA. What is the reason for NOT having it? Does Microsoft expect us to code in another way? Maybe use more function or sub calls? I can use GoTo s with labels but they are ugly.

 

[mikerickson]

Nested IF..End IF

Do
    ' do stuff
    If rule-is-followed Then
        ' do more stuff
        If rule-is-followed Then
            ' do more
        End If
    End If
Loop Until Done.

 

[bklabel1]

Stay inside of the inner do. Break out as needed but remain inside of the outer loop. The inside one keeps spinning so it has a break at the end.
Is this something used in VBA?

Do
get next row of data
Do while (true)
IF this rule is broken, report it and Exit Do
IF this rule is broken, report it and Exit Do
IF this rule is broken, Exit Do
Always Exit Do here.
Loop until no more rows to examine in file
Loop

 

[bklabel1]

My indentation was lost. I don't know how to edit a post so I will repost.

Do
  get next row of data
  Do while (true)
      IF this rule is broken, report it and Exit Do
      IF this rule is broken, report it and Exit Do
      IF this rule is broken, Exit Do
      Always Exit Do here.
  Loop until no more rows to examine in file
Loop