[This followup was posted to microsoft.public.excel.programming and a
copy was sent to the cited author.]

I assume you want unique selections. In addition to the sort method
suggested, check the Excel | Tutorials | 'Random Selection' page of my
web site.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2003
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office


In article ,
says...
I would like to generate some random numbers - 10 at a
time - from a list in range a1:a70
Is there an Excel or VBA Ssolution please
Barry