this might be a stupid q to ask but...

I have created 6 macros that I run one after another to perform my task.
Istead of running them one after another I'd like a sub that calls one by one
(in the right order), insted of doing it myself. What would the code be?

I know i can paste the code of each one into the first to make one sub, but
I need the subs like this to individually use them in other tasks.

Thank you,

Steven.

Hi, in the one sub after its last line and before the End Sub statement, call
the next sub. This should solve all your requirements.

"steven" wrote:

this might be a stupid q to ask but...

I have created 6 macros that I run one after another to perform my task.
Istead of running them one after another I'd like a sub that calls one by one
(in the right order), insted of doing it myself. What would the code be?

I know i can paste the code of each one into the first to make one sub, but
I need the subs like this to individually use them in other tasks.

Thank you,

Steven.

sub runmacros()
call sub1
call sub2
'etc
end sub

--
Don Guillett
SalesAid Software

"steven" wrote in message
...
this might be a stupid q to ask but...

I have created 6 macros that I run one after another to perform my task.
Istead of running them one after another I'd like a sub that calls one by
one
(in the right order), insted of doing it myself. What would the code be?

I know i can paste the code of each one into the first to make one sub,
but
I need the subs like this to individually use them in other tasks.

Thank you,

Steven.

id rather have one sub that calls subs 1-6 one by one in the right order...
can this be done?

Steven.

"Madhan" wrote:

Hi, in the one sub after its last line and before the End Sub statement, call
the next sub. This should solve all your requirements.

"steven" wrote:

this might be a stupid q to ask but...

I have created 6 macros that I run one after another to perform my task.
Istead of running them one after another I'd like a sub that calls one by one
(in the right order), insted of doing it myself. What would the code be?

I know i can paste the code of each one into the first to make one sub, but
I need the subs like this to individually use them in other tasks.

Thank you,

Steven.