is the do While doing anything or is that your attempt to break out of the
for next loop. If so, the do while or do unil or loop While or loop until
are all external to the for next loop and would have no effect (conditions
are checked at the Do or Loop line). If you want to break out of the for
next loop

for i = 1 to 10
if val1 = val2 then
exit for
end if
Next

--
Regards,
Tom Ogilvy



" wrote in message
oups.com...
Which of these should break out of a For Next Loop when x = 1?
I think I'm getting the same action either way. I want it to break when
x = 1 and skip the rest of the For/Next

x = 0
Do While x = 0
For i = 1 to 10
If val1 = val2 Then
x = 1
End If
Next i
Loop

x = 0
Do Until x = 1
For i = 1 to 10
If val1 = val2 Then
x = 1
End If
Next i
Loop