Start a Macro within another Macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scott Wagner - 28 Feb 2006 12:49 GMT

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"

Reply to this Message

Chip Pearson - 28 Feb 2006 12:53 GMT

> 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.

Signature

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

> This is a really easy one...
>
[quoted text clipped - 3 lines]
>
> Application.Run "testing.xls!DeleteBoldOtto"

Reply to this Message

Bob Phillips - 28 Feb 2006 12:56 GMT

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

DeleteBoldOtto

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> This is a really easy one...
>
[quoted text clipped - 3 lines]
>
> Application.Run "testing.xls!DeleteBoldOtto"

Reply to this Message