Start a Macro within another Macro
 

This is a really easy one...

How do I start another macro from within another Macro?

Is this the best method?

Application.Run "testing.xls!DeleteBoldOtto"

Start a Macro within another Macro
 

Is this the best method?

Application.Run "testing.xls!DeleteBoldOtto"

No, that is the worst method. It is very slow because VBA must
find, at run time, the specified procedure. To call one macro
from another, just type the macro name.

Sub AAA()
TheMacro
End Sub

You can also use the Call statement:

Sub AAA()
Call TheMacro
End Sub

but the Call is strictly optional.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Scott Wagner" wrote in
message
...
This is a really easy one...

How do I start another macro from within another Macro?

Is this the best method?

Application.Run "testing.xls!DeleteBoldOtto"

Start a Macro within another Macro
 

If the macro is in the same workbook, just call it

DeleteBoldOtto

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Scott Wagner" wrote in message
...
This is a really easy one...

How do I start another macro from within another Macro?

Is this the best method?

Application.Run "testing.xls!DeleteBoldOtto"