http://www.tushar-mehta.com/excel/ne...ion/index.html

--
Kind regards,

Niek Otten

"Terence" wrote in message
...
I would like to create 30 random numbers in cells A1 to A30 that are
between
1 and 2000, and I do not want duplicates. For example, I don't want cells
A5
and A22 to return 1752.