exit Loop if macro error

[Erick]

I have a Do ...Loop Until command in my macro. Is it possible to have a command within this loop to exit the loop if the macro encounters any error?

 

[Zack Barresse]

have you tried:

on error exit sub

?

 

[erik.van.geit]

"on error exit sub" doesn't exist to my knowledge

example:

Sub a()
On Error GoTo skip
Do
aaa = aaa + 1
Columns(aaa).Select
Loop
Exit Sub
skip:
MsgBox "column " & aaa & " doesn't exist"
End Sub

regards,
Erik