Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Looping | Excel Discussion (Misc queries) | |||
Not Looping | Excel Discussion (Misc queries) | |||
Looping till value is 1? | Excel Discussion (Misc queries) | |||
Looping | Excel Discussion (Misc queries) | |||
looping trouble | Excel Discussion (Misc queries) |