I would like to have a second macro kick off after the first macro has
completed its tasks. How can I go about doing this? I could do a cut and
paste of the language for the second macro into the body of the first but am
assuming that there is a better way to do this.

Thoughts?

Thanks
--
sd

As long as the macros are in the same module, you can just put the name of
the second macro on the last line of the first macro. That will call the
second macro.

Sub Macro1()
...
...
...
Macro2
End Sub

--

Vasant

"iamn94" wrote in message
...
I would like to have a second macro kick off after the first macro has
completed its tasks. How can I go about doing this? I could do a cut and
paste of the language for the second macro into the body of the first but
am
assuming that there is a better way to do this.

Thoughts?

Thanks
--
sd

Sub Macro1()
' existing code

Macro2 ' starts macro2
End Sub

--
Regards,
Tom Ogilvy

"iamn94" wrote in message
...
I would like to have a second macro kick off after the first macro has
completed its tasks. How can I go about doing this? I could do a cut and
paste of the language for the second macro into the body of the first but
am
assuming that there is a better way to do this.

Thoughts?

Thanks
--
sd