lottery number generator

[timostag]

I am making a lottery number generator, using VBA excel.

I'm okay with writing the code to generate the numbers but, I also need to re-order the 6 numbers generated into ascending order and then have them stored.

I'm guessing I need to transfer the numbers onto an excel spreadsheet to re-order them and then store them, but I have NO idea how too as I am completely new to all this

 

[Poppa Smurf]

Have a look at this site http://www.iansharpe.com/art_excel_random.php. It uses the RAND function to generate lottery numbers.