Do loops when to use them??

[Alpacino]

Hi just a quick question. When do you use a do loop oe do until loops?? I use a few for next but never understand when you use do loops can someone explain or give an example of when to use them.

Thanks

 

[shg]

Sub x()
    If 1 = 0 Then
        MsgBox "Surprise"
    ElseIf 1 = 1 Then
        MsgBox "No Surprise"
    Else
        MsgBox "Surprise"
    End If
End Sub

 

[BrandonWLH]

My god, even at 35 I can be an idiot.

You realize I've been developing xls for 6 months working around not having an elseif because I wasn't using it right.....

Lemme just go kill myself right now... sorry folks. this old dog learned a new trick.

 

[Alpacino]

I worked it out the cells had conditional formatting in them thats why it seemed like it didnt work. I removed the cond format and it worked!!!