could any one please tell me how can i create a macro that runs other macro
 

How would I create a macro that runs 4 different macros in the same
workbook. Assume the names of those 4 macros as Step1, Step2, Step3,
Step4.

So how would i create another macro (say, name it as StepAll) that
would run sequentially all the 4 macros (i.e. Step 1, 2, 3,4)

HELP

Thanks
Dhaval K

could any one please tell me how can i create a macro that runs ot
 

The easiest way is to write another macro that calls each of the others.

For example:

sub StepAll()
step1
step2
step3
step4
End Sub

This will run them in the order presented.


"VB Script for Excel" wrote:

How would I create a macro that runs 4 different macros in the same
workbook. Assume the names of those 4 macros as Step1, Step2, Step3,
Step4.

So how would i create another macro (say, name it as StepAll) that
would run sequentially all the 4 macros (i.e. Step 1, 2, 3,4)

HELP

Thanks
Dhaval K

could any one please tell me how can i create a macro that runs other macro
 

sub stepAll
Step1
Step2
Step3
Step4
end sub


HTH
--
AP

"VB Script for Excel" a écrit dans le message de
ups.com...
How would I create a macro that runs 4 different macros in the same
workbook. Assume the names of those 4 macros as Step1, Step2, Step3,
Step4.

So how would i create another macro (say, name it as StepAll) that
would run sequentially all the 4 macros (i.e. Step 1, 2, 3,4)

HELP

Thanks
Dhaval K