Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How do you run two macros in series. I have to do this because a macro
exceeded 64k and had to be split into two macros. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Sub InSeries()
Call Macro1 Call Macro2 End Sub -- Gary''s Student - gsnu200785 "mulehead" wrote: How do you run two macros in series. I have to do this because a macro exceeded 64k and had to be split into two macros. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks Gary, I will try your suggestion!
"Gary''s Student" wrote: Sub InSeries() Call Macro1 Call Macro2 End Sub -- Gary''s Student - gsnu200785 "mulehead" wrote: How do you run two macros in series. I have to do this because a macro exceeded 64k and had to be split into two macros. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Gary, It works perfectly, thanks again.
"Gary''s Student" wrote: Sub InSeries() Call Macro1 Call Macro2 End Sub -- Gary''s Student - gsnu200785 "mulehead" wrote: How do you run two macros in series. I have to do this because a macro exceeded 64k and had to be split into two macros. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
Sub Macro1() YourCode Call Macro2 End Sub Sub Macro2 Your Code End Sub Regards, Per "mulehead" skrev i meddelelsen ... How do you run two macros in series. I have to do this because a macro exceeded 64k and had to be split into two macros. |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you Per, I will try this!
"Per Jessen" wrote: Hi Sub Macro1() YourCode Call Macro2 End Sub Sub Macro2 Your Code End Sub Regards, Per "mulehead" skrev i meddelelsen ... How do you run two macros in series. I have to do this because a macro exceeded 64k and had to be split into two macros. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
"openinf file..."ENABLE MACROS...DISABLE MACROS" | Excel Discussion (Misc queries) | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions |