How does RND generate random numbers..is it updated the way Rand () is in Excel 2003?

rnd is part of vba 6. VBA6 hasn't changed since xl2000 - at least there
hasn't been a version change.

http://support.microsoft.com/default...47&Product=vbb
INFO: How Visual Basic Generates Pseudo-Random Numbers for the RND Function

--
Regards,
Tom Ogilvy



"Leigh" wrote in message
...
How does RND generate random numbers..is it updated the way Rand () is in
Excel 2003?

Thanks, so it doesn't have the same issues associated with it that Rand() did/does (once you install the office update)?

I am not sure what issues you refer to. If you mean the negative random
numbers in Excel 2003, then no, it isn't affected by those issues to the
best of my knowledge.

--
Regards,
Tom Ogilvy

"Leigh" wrote in message
...
Thanks, so it doesn't have the same issues associated with it that Rand()
did/does (once you install the office update)?

If you are referring to the production of negative numbers by RAND() in
the original release of Excel 2003, that was repared by a hotfix earlier
this year. With the hotfix, RAND() should have considerably better
statistical properties than the VBA Rnd() function.

Jerry

Leigh wrote:

Thanks, so it doesn't have the same issues associated with it that

Rand() did/does (once you install the office update)?