Not true!

You are creating a random selection for each selection, therefore there is
an equal chance (within the probability density of the randomising process)
to get 1 to 49 each time. The seed applies for each selection event so the
probabilities stay the same.
You will not limit the series to a subset of the possible permutations.

The only issue is that you could randomly select one of the numbers already
in the series, so your true probability is not reduing as it is in the
'real' selection process. But since you reject that and reselect another
number the outcome is not affected.

Still does not improve your chances of winning the real loto though!

Cheers
Nigel

"alainB " wrote in message
...
Thanks!

If you draw 6 numbers out of 49, put them back and do it again, the
chance for the second serie to be the same as the first one is about 1
in 15 millions (more or less a few millions, I suppose??).

Because the computer generate a pseudo random number, and it is base
based on the timer seed, I remember somebody saying somewhere that it
was not possible to generate more than 60 or 70 thousands differents
series.

If so, my macro would not be good at all.

??

Alain


---
Message posted from http://www.ExcelForum.com/