R
Ray
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
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