Skip part of macro on re-run?
 

HI all -

I hope an MVP (or at least someone more experienced that myself) can
help ...

Is it possible to start running a macro part way through the code? An
example should help clarify:
Macro A has 10 steps (1-10) and is called by a commandbutton -- Steps
1&2 basically prep the effected worksheets to complete Steps 3-8.
Steps 9&10 add some formatting and error-checking.

If errors exist (step 10), Macro B reverses the results of Steps 9&10
(of Macro A) -- columns are deleted, formatting erased, etc.

Now, I want to have macro C be able to run steps 3-10 of Macro A --
can I tell it to run Macro A starting at step 3? how would I do this?

Or, do I just need to replicate the code for steps 3-10 in Macro C?

The solution to this specific case will be very useful in other
Projects, for sure ...!

TIA, Ray

Skip part of macro on re-run?
 

Ray,

If you break up macro A into 10 steps and use macro 1 to run steps 1-10, you
could use macro 2 to run steps 3-10.

Jim

"Ray" wrote:

HI all -

I hope an MVP (or at least someone more experienced that myself) can
help ...

Is it possible to start running a macro part way through the code? An
example should help clarify:
Macro A has 10 steps (1-10) and is called by a commandbutton -- Steps
1&2 basically prep the effected worksheets to complete Steps 3-8.
Steps 9&10 add some formatting and error-checking.

If errors exist (step 10), Macro B reverses the results of Steps 9&10
(of Macro A) -- columns are deleted, formatting erased, etc.

Now, I want to have macro C be able to run steps 3-10 of Macro A --
can I tell it to run Macro A starting at step 3? how would I do this?

Or, do I just need to replicate the code for steps 3-10 in Macro C?

The solution to this specific case will be very useful in other
Projects, for sure ...!

TIA, Ray