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