Something more ...
I have revised the code I posted earlier.
It now can generate up to 6,500,000 numbers with the specified average
and the upper and lower constraints.
(3 million numbers run in about 8 seconds using xl2002 on my machine)

It comes in a workbook...click the button, fill in the options and off you go.
If you or others are interested in a free copy, you can email me direct and
request it. I respond best to those with real names and a location.
Remove xxx from my email address - XX
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"rcc"
wrote in message
Thanks, Jim.



"Jim Cone" wrote:
Specify the parameters: low, high, average and set size.
Set size is limited to the number of cells in a row, however, with
minor modifications the set size could be increased to the number
of cells in a column.
-snip-