Running a Macro from another Macro

  • Thread starter Thread starter Stan
  • Start date Start date
S

Stan

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
 
Sub Dount1
' your other code

Call GenRand

' your other code
End Sub

The 'Call' is optional
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro on All Sheets Q 8
Run code from another workbook 7
stopping a range from calculating 5
Do until loop with use of another macro in loop 9
Run another macro from within this macro 13
Is there something wrong with the random generator in Excel? 14
Macro shortcuts are running macros in different open workbook 3
Macro to generate powerpoint slides 43

Back
Top