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.

Invoking a macro from within another
 

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.

Invoking a macro from within another
 

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

Invoking a macro from within another
 

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.