Better Random Number Generator

[WannaBeExceller]

I was wondering if I could get a better random number generator than the one
in excel. I was also wondering if the VB generator is any better than the VBA
generator. Thanks in advance.

[Tom Ogilvy]

If you are using xl2003, the random number generator has been greatly
improved.

--
Regards,
Tom Ogilvy

"WannaBeExceller" <WannaBeExceller@discussions.microsoft.com> wrote in
message news:59F1B815-3E07-4164-914F-D2D32861A3DF@microsoft.com...
> I was wondering if I could get a better random number generator than the
one
> in excel. I was also wondering if the VB generator is any better than the
VBA
> generator. Thanks in advance.

[Edwin Tam]

"Excel Power Expander" contains a very "detailed" random number generator. It
allows you to generate different type of random numbers, including normal
distribution, exponential, etc. Also, it includes "random seed"
implementation. (You can generate the same set of numbers at any time.)

Also, besides random numbers, it can generate random characters, etc.

Detailed documentation included.

http://www.vonixx.com

Regards,
Edwin Tam


"WannaBeExceller" wrote:

> I was wondering if I could get a better random number generator than the one
> in excel. I was also wondering if the VB generator is any better than the VBA
> generator. Thanks in advance.

[trivia21]

You can also use the random number generator of the Microsoft Cryptographic Provider. This is said to be even cryptographically random. The code can be added as a class module (or a module).

Please Login or Register  to view this content.