Do Loop Question

[mikeymay]

Is it possible to use more than one condition in a Do Loop?

E.g.

Do Until Selection = "Yes" & Selection.offset(0,1) = "Yes"
         Selection.Offset(1,0).select
Loop

 

[VoG]

Yes, like this

Do Until Selection = "Yes" And Selection.Offset(0, 1) = "Yes"
         Selection.Offset(1, 0).Select
Loop

 

[mikeymay]

Thanks VoG. I knew I had done this before and couldn't understand why it didn't work anymore......the simple things.....