Did you look at the poptools addin suggest by Joe. It says its random
number generator is slower, but that may be a relative statement and of not
much consequence - I don't know, because I haven't used it.

http://sunsite.univie.ac.at/Spreadsite/poptools/

--
Regards,
Tom Ogilvy

"OnceTall" wrote in message
oups.com...
I have tested the cycle time of the Rnd function in VBA, and it is
something like 16,700,000. After that many numbers, the entire cycle
repeats itself.

That may seem like a lot of numbers, but I often have need for more
than that. Does anyone have an add-in that generates more random
numbers and is pretty quick?

Thanks.