View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ABG ABG is offline
external usenet poster
 
Posts: 8
Default 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