View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Running one macro from another

Not to me.

You can put them in different modules (if the subroutines get very large)--or if
it makes more sense from a organization aspect.



Megadrone wrote:

it's running them both at the same time. I have these Sub's in the same
module is that a problem?

"Dave Peterson" wrote:

Maybe...

Option Explicit
Sub RunBoth()
call FirstMacro
Call SecondMacro
end sub



Megadrone wrote:

I have a macro that takes info from a Master spreadsheet & generates a
separate spreadsheet. I have another macro that takes that generated
spreadsheet & generates another spreadsheet. My question is: How can I run
these as two macros as one single Macro?


--

Dave Peterson


--

Dave Peterson