Code to stop macro

[mike.schultz]

If I'm running a if statement in a sub macro of a macro, how can i end it with exiting the sub macro?

 

[hedrijw]

You can use the Stop statement, i.e.

If [A1] = "" Then
Stop
End If

You can also use the debugger to set breakpoints

 

[Haluk]

On 2002-10-29 13:58, mike.schultz wrote:
If I'm running a if statement in a sub macro of a macro, how can i end it with exiting the sub macro?

You can use a GoTo statement.