Looping several codes
 

Is there an easy way to have one macro that runs several. I have 11 different
sheets that all have a transfer data macro written, I would like to have one
button to force all of the code to run. Is there an easy way? Thansk in
advance for your help
--
Thank you for your time!
John

Looping several codes
 

If the macro runs against the activesheet, then the simplest may be to just
select each sheet and call the macro:

Option Explicit
Sub RunThemAll()

Dim wks as worksheet
for each wks in activeworkbook.worksheets
wks.select
call yourmacronamehere
next wks

End sub

Very Basic User wrote:

Is there an easy way to have one macro that runs several. I have 11 different
sheets that all have a transfer data macro written, I would like to have one
button to force all of the code to run. Is there an easy way? Thansk in
advance for your help
--
Thank you for your time!
John

--

Dave Peterson