As long as you want no more than 100 numbers...
Random Selection
http://www.tushar-mehta.com/excel/ne...ion/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
How do I generate random numbers from 1 to 100 without any repeated numbers?
Am using Excel 2003.