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