Just call the other macro from within your code

Sub CallerMacro()
Msgbox "hello"
' more code

CalledMacro

' more code
End Sub

Sub CalledMacro()
...
End Sub

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Brian Matlack"
wrote in message
news:Brian.Matlack.2144cm_1136382002.1785@excelfor um-nospam.com...

Hi!
I started out in Lotus 123. In that application if I told a macro to
"Branch" to another macro it would run that macro and then end. If I
told it to "Run" a macro it would run that macro and then return to the
original macro and continue on.
How does it work in Excel VBA? I currently use an IF and then END
statement to "Branch" to another macro but is there a better way?
Any help or examples would be greatly appreciated.


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile:
http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=497878