#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 18
Default Macros

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default Macros

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 18
Default Macros

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 18
Default Macros

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,533
Default Macros

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 18
Default Macros

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 macros - how to merge 5 macros together into one Sue Excel Discussion (Misc queries) 1 April 16th 08 08:36 PM
Macros warning always shows up, even if all macros removed Joe M Excel Discussion (Misc queries) 1 December 20th 07 04:45 AM
Macros - copying macros from one computer to another TT Excel Discussion (Misc queries) 18 December 14th 06 03:24 AM
"openinf file..."ENABLE MACROS...DISABLE MACROS" F. Lawrence Kulchar Excel Discussion (Misc queries) 3 September 12th 06 10:33 AM
Training: More on how to use macros in Excel: Recording Macros ToriT Excel Worksheet Functions 2 February 10th 06 07:05 PM


All times are GMT +1. The time now is 11:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"