Hello all,
thanks for the comments so far.
> Oddly enough, the worksheet RAND function, ATP routines (including
> RANDBETWEEN), and the VBA Rnd function all use different algorithms. None
> were very random before Excel 2003. Only the worksheet RAND function was
> improved in 2003.
That's really interesting. Any way to access the worksheet RAND
function from within Excel, by some construction like Call
ExcelWorksheetFunction.RAND() or something similar?
> RANDBETWEEN may be more convenient, but should not be used
> where serious randomness is required.
I couldn't care less about convenience :-) - I just want a truly random
double between 0 and 1 :-)
Al
Bookmarks