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