davidhall80
Well-known Member
- Joined
- Jul 8, 2006
- Messages
- 663
Is there an on error exit sub command. I would like my Macro to just stop running if there is an error instead of an error message popping up. Thanks in advance
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
On error Exit Sub
- Thread starter davidhall80
- Start date
Norie
Well-known Member
- Joined
- Apr 28, 2004
- Messages
- 76,377
- Office Version
- 365
- Platform
- Windows
David
There isn't but you could use a structure like this.
But why not try and eliminate the error in the first place.
There isn't but you could use a structure like this.
Code:
On Error Goto MyExitSub
' code here
MyExitSub:
Msgbox "There's been an error so I'm bailing out."
End
End Sub
Upvote
0
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
No but you can do this:
Code:
Sub Test()
On Error GoTo ErrorHandler
' Some code
Exit Sub ' Exit to avoid handler.
ErrorHandler:
End Sub
Upvote
0
Similar threads
- Question
