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 **************************************************