Random Number

  • Thread starter Thread starter Tony C
  • Start date Start date
T

Tony C

I am using a line of code, to randomly pick out a number
from a known range

draw_no = Int(draw_value * Rnd)

draw_value is the count of the numbers to be drawn. In
this case it's 22.

draw_no is 'the winning number'

Trouble is, it's not random. It returns the same run of
values every time I use it.

Not really random. Any ideas please
 
Read about
rondomize
in the help file.

This initializes the generator...
 
You might note that 22 would never get selected. Assuming you don't have a
zero but have 22 entrants:

Draw_Value = 22
draw_no = Int(draw_value * Rnd + 1)

or

draw_no = Int(draw_value*Rand) + 1
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

random number generation help 3
Pickup Data from a Worksheet 3
Produce Random Numbers 6
Six columns randon no.'s no dupes 6
random not truely random. 3
Populating 2 ranges with different random nums in each cell 7
buidling randomize function that not repeating the same number 2
Modify working code to expand the output. 5

Back
Top