Lottery

[Aegis1]

Hello folks, have a question a friend asked me.... is there a way in excel 2000 to randomly select numbers 1-52 just like a lottery does?????? Thanks

 

[Rollin_Again]

Here is an example using a user-defined function. It allows you to select the range of numbers to select from and also lets you select how many random numbers you want returned.

http://www.ozgrid.com/VBA/RandomNumbers.htm

Here is a simple condensed version that generates one number at a time. The function takes two arguments (lowest and highest) These numbers represent the first and last number in the selection range.

Public Function RandomNumber(Lowest As Long, Highest As Long)
   Randomize
   RandomNumber = Int(Rnd * (Highest + 1 - Lowest)) + Lowest
End Function

Rollin

 

[Aegis1]

Rollin, Thanks for the link it worked out just fine I'll let you know if she wins anything..............