Looping several codes

  • Thread starter Thread starter Very Basic User
  • Start date Start date
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
 
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
 
Back
Top