Utilizing Same Macros for Different Processes

[madhuchelliah]

Hello guys, I have totally 30 macros for processes. I have 2 processes 1st consists of 20 macros and 2nd consists of all 30 macros. In my 20th macro i have given a message box as completed. For my 2nd process i want to continuously run the macro after 20th to 21st without message box. Now i am using by duplicating macros with different names. It is very difficult to maintain. Is there any method to utilize same macros for both the processes?. Thank you.

 

[mole999]

can't imagine what your macros look like, could there be a way of looping through them ?. The short answer yes it can be done, by declaring a variable in one part of the code and changing what is passed

 

[madhuchelliah]

Hello Mole, Thanks for the response. I have 30 individual macros. Using call function i am running the macros. Could you pls give any example to do that. My 20th macro contains just the cell alignment and message box. After this alignment i want to trigger my 21st macro.

 

[mole999]

OK, basic outline


Declare a Global Variable i.e, X

sub main
X = 3
Call Loop
X = 6
Call Loop
X = 7
Call Loop
Exit Sub

Sub Loop
use X in code
Exit Sub

as you run down main each part is called as necessary, the value of X is changed and Loop is reused

If you have a run of numbers you might want to consider a second Loop for some differences you can't bring into the main macro, you might use FOR NEXT for X = 1 to 250 NEXT x