Because random includes duplicates. If there weren't duplicates, they
wouldn't be "random".
Try this:
http://www.ozgrid.com/VBA/RandomNumbers.htm
*******************
~Anne Troy
www.OfficeArticles.com
"Gloria" wrote in message
...
Why do I get duplicate numbers when I use the formula for random
numbering.