PC Review


Reply
Thread Tools Rate Thread

Can a Macro Run Another Macro

 
 
Bob
Guest
Posts: n/a
 
      18th Mar 2008
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.

--
Bob
 
Reply With Quote
 
 
 
 
Gary''s Student
Guest
Posts: n/a
 
      18th Mar 2008
sub hello()
Call qwerty
End Sub
--
Gary''s Student - gsnu200774
 
Reply With Quote
 
JLGWhiz
Guest
Posts: n/a
 
      18th Mar 2008
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.


"Bob" wrote:

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

 
Reply With Quote
 
Bob
Guest
Posts: n/a
 
      18th Mar 2008
Thanks JLG - it works perfectly.
--
Bob


"JLGWhiz" wrote:

> 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.
>
>
> "Bob" wrote:
>
> > 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.
> >
> > --
> > Bob

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro recorded... tabs & file names changed, macro hangs Steve Microsoft Excel Worksheet Functions 3 30th Oct 2009 11:41 AM
::: Sort macro with empty lines at the end. ::: Macro de tri avec lignes vide en bas. infojacques@gmail.com Microsoft Excel Discussion 2 5th Jul 2007 11:40 AM
Macro not showing in Tools/Macro/Macros yet show up when I goto VBA editor karll@swfab.com Microsoft Excel Programming 2 30th Mar 2007 07:48 PM
Run Macro On Open event for report and SetValue Macro has wierd error ThompsonJessical@yahoo.com Microsoft Access Macros 2 2nd Aug 2005 05:51 PM
Start Macro / Stop Macro / Restart Macro Pete Microsoft Excel Programming 2 21st Nov 2003 05:04 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:04 PM.