| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a Macro Run Another Macro
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can a Macro Run Another Macro
sub hello()
Call qwerty End Sub -- Gary''s Student - gsnu200774 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can a Macro Run Another Macro
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| AutoRun Macro with a delay to give user the choice to cancel the macro | Excel Programming | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Linear Mode
