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)?