Can a Macro Run Another Macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob - 18 Mar 2008 17:28 GMT

I would like to know if a Macro can run another Macro - sort of a "Master
Macro".
The 5 macro's I have now are titled "CopyCell1", "CopyCell2", "CopyCell3,
"CopyCell4 and "DeleteRowifZeroInA.
Is it possible to develop one that will run all?

Thanks.

Signature

Bob

Reply to this Message

Gary''s Student - 18 Mar 2008 17:30 GMT

sub hello()
Call qwerty
End Sub

Signature

Gary''s Student - gsnu200774

Reply to this Message

JLGWhiz - 18 Mar 2008 18:16 GMT

If all of you macros are in the same module in the same workbook then you can
run them from a master macro like this:

Sub MaterMacro()
CopyCell1
CopyCell2
CopyCell3
CopyCell4
DeleteRowIfZeroInA
End Sub

If you have them in different modules you will need to
specify the location like Sheet1!CopyCell2.

> I would like to know if a Macro can run another Macro - sort of a "Master
> Macro".
[quoted text clipped - 3 lines]
>
> Thanks.

Reply to this Message

Bob - 18 Mar 2008 19:07 GMT

Thanks JLG - it works perfectly.

Signature

Bob

> If all of you macros are in the same module in the same workbook then you can
> run them from a master macro like this:
[quoted text clipped - 17 lines]
> >
> > Thanks.

Reply to this Message