Invoking a macro from within another

Can't figure this out.

I want a macro to run another macro or several other macros. How do you do
it?

Thanks...I know this should be simple, but I can't find the solution
anywhere.

Hi

It is literally as simple as:

Sub MyMacro()
MyOtherMacro
End Sub

Sub MyOtherMacro()
Msgbox "Hello, World!"
End Sub

You don't need to use the Call statement.

Hope this helps!

Richard

Sub RunMacro
MyTest
MyOutput
end sub

sub MyTest
msgbox "this is my test"
end sub

sub MyOutput
msgbox "this is my output"
end sub


in other words, just put the name of the sub and it will run.

Thanks - that was easy.


"jnsaunders" <[email protected]> wrote in message
news:%230Eu2g%[email protected]...
> Can't figure this out.
>
> I want a macro to run another macro or several other macros. How do you do
> it?
>
> Thanks...I know this should be simple, but I can't find the solution
> anywhere.
>