Looping several codes

V

Very Basic User

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
 
D

Dave Peterson

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
 
Top