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.

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.

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


--
RichardSchollar
------------------------------------------------------------------------
RichardSchollar's Profile: http://www.excelforum.com/member.php...o&userid=34698
View this thread: http://www.excelforum.com/showthread...hreadid=546683

Thanks - that was easy.


"jnsaunders" wrote in message
...
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.