Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running a Macro from another Macro
How do I run a macro from within another macro?
Example: I have a macro (Dount1) which is basically a *Do Until* loop dependent on the results of a random number generator held in a macro called *Genrand*. I want to run Genrand from Dount1 until a certain random number sequence is generated. TIA Stan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running a Macro from another Macro
Sub Dount1
' your other code Call GenRand ' your other code End Sub The 'Call' is optional -- Regards, Nigel "Stan" wrote in message ... How do I run a macro from within another macro? Example: I have a macro (Dount1) which is basically a *Do Until* loop dependent on the results of a random number generator held in a macro called *Genrand*. I want to run Genrand from Dount1 until a certain random number sequence is generated. TIA Stan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Different results when running macro vs stepping into macro | Excel Programming | |||
Report with macro losing links to a particular worksheet after running macro | Excel Programming | |||
disable user running macro from Tools Macro | Excel Discussion (Misc queries) | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
Launch Macro in Access via Macro running in Excel??? | Excel Programming |