You might also be interested in this sample file:
http://savefile.com/files/7565212
Randomization_Lotto_program.xls
(Save the file to disk and open from there)

The sample utilizes the RandLotto* UDF as the core functionality
*by Dave Hawley & JE McGimpsey
(From: http://www.ozgrid.com/VBA/RandomNumbers.htm)

---
In sheet: Draw,
just change the "Settings" to suit (From, To, Pick#)
and then click the "Draw" button
(One click draws one random set of numbers)

Results will be written in G2 down
Click "Reset" to clear col G
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---