In the same way that you can start a second sub from within a sub by using
the command

call mymacro

is there a corresponding command to then stop that subroutine?

Should be obvious but I'm struggling with the answer

The stopping condition would have to be written into the called routine.


Gord Dibben MS Excel MVP

On Sun, 28 Dec 2008 19:03:16 -0000, "teepee" wrote:


In the same way that you can start a second sub from within a sub by using
the command

call mymacro

is there a corresponding command to then stop that subroutine?

Should be obvious but I'm struggling with the answer

Hi,

If you are running macroX and you want it to stop based on some condition

If x then Exit Sub

where x is the condition that triggers the macro to stop.

If this helps, please click the Yes button

cheers,
Shane Devenshire

"teepee" wrote in message
...

In the same way that you can start a second sub from within a sub by using
the command

call mymacro

is there a corresponding command to then stop that subroutine?

Should be obvious but I'm struggling with the answer

Thanks for the answers. Much appreciated