Stopping point for a macro

**benno87** · 05-26-2009, 11:00 PM

Hi,

I have 2 macro's (macroA, macroB). If I select macroA, it will run the full code.

If I select macroB, I want it to run macroA up to a certain point. Is this possible?

Can I also 'skip' part of macroA, so I can continue the macro at a later piont?

Thanks for your help

**shg** · 05-27-2009, 12:23 AM

You can stop a macro at any point with an Exit Sub statement.

**benno87** · 05-27-2009, 12:38 AM

If I run macroB, I want macroA to run up to a certain point. In macro2, this is the code I have:

Please Login or Register  to view this content.

But it runs the whole code of macroA. Is there something I can put into macroA to essentially say: if activated by macroB, then run to this point or exit sub at a certain point?

I appreciate your response

**Andy Pope** · 05-27-2009, 05:16 AM

You would need to use a private variable to let MacroA know that macrob called it.

Please Login or Register  to view this content.

**benno87** · 05-28-2009, 03:20 AM

Hi,

Thanks for this but i also have some loops in my code of macroA also and each time i run the code, it says that the variable is not defined and selects "Cell" in "For Each Cell In...."

Does this usually effect a Boolean variable?

Cheers

**Andy Pope** · 05-28-2009, 04:37 AM

It's because my code example includes the Option Explicit instruction which requires you to declare all variables in the module.

Either declare all variables or remove the line.