atw: Re: Word/Excel macro/method to assign numbers randomly

Thanks very much Craig & Andrea.
-----Original Message-----
From: Craig Hadden [mailto:CraigH@xxxxxxxxxxxxxxxxxxx]
Sent: Friday, 23 July 2004 3:01 PM
To: 'austechwriter@xxxxxxxxxxxxx'
Subject: atw: Re: Word/Excel macro/method to assign numbers randomly


Janet, the built-in Rnd function is what you need.
 
>From the VBA Help on that function:
: Before calling Rnd, use the Randomize statement without an argument to
: initialize the random-number generator with a seed based on the system
timer.
:
: To produce random integers in a given range, use this formula:
: Int((upperbound - lowerbound + 1) * Rnd + lowerbound)
 
Regards,
Craig
**************************************************
To post a message to austechwriter, send the message to
austechwriter@xxxxxxxxxxxxxx

To subscribe to austechwriter, send a message to
austechwriter-request@xxxxxxxxxxxxx with "subscribe" in the Subject field.

To unsubscribe, send a message to austechwriter-request@xxxxxxxxxxxxx with
"unsubscribe" in the Subject field.

To search the austechwriter archives, go to
www.freelists.org/archives/austechwriter

To contact the list administrator, send a message to
austechwriter-admins@xxxxxxxxxxxxx
**************************************************


**************************************************
To post a message to austechwriter, send the message to 
austechwriter@xxxxxxxxxxxxxx

To subscribe to austechwriter, send a message to 
austechwriter-request@xxxxxxxxxxxxx with "subscribe" in the Subject field.

To unsubscribe, send a message to austechwriter-request@xxxxxxxxxxxxx with 
"unsubscribe" in the Subject field.

To search the austechwriter archives, go to 
www.freelists.org/archives/austechwriter

To contact the list administrator, send a message to 
austechwriter-admins@xxxxxxxxxxxxx
**************************************************

Other related posts: