-
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.
Exit sub, end and stop [what are the differences of this lines...]
- Thread starter pedie
- Start date
Hermanito
Well-known Member
- Joined
- Apr 4, 2007
- Messages
- 1,238
They certainly don't do the same thing...
Exit Sub (or Exit Function) will immediately exit from the sub or function it is in. If that sub or function was called from other code, the program will continue in that other code, right after the call to the sub or function you just left...
End will also exit from any sub or function, but it will not return to any calling sub or function. This will effectively stop all macro execution and return full control to the user.
Stop is used in a debugging phase of your macro's. At any place you put a Stop, the code will be interrupted, with the debugger highlighting that line, after which you can continue debugging with stepping through code etc...
Exit Sub (or Exit Function) will immediately exit from the sub or function it is in. If that sub or function was called from other code, the program will continue in that other code, right after the call to the sub or function you just left...
End will also exit from any sub or function, but it will not return to any calling sub or function. This will effectively stop all macro execution and return full control to the user.
Stop is used in a debugging phase of your macro's. At any place you put a Stop, the code will be interrupted, with the debugger highlighting that line, after which you can continue debugging with stepping through code etc...
Upvote
0
