View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default 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