You wrote:
>We had contacted Microsoft to see if you could reset the seed in Excel
>(which would be a nice thing if you wanted to reproduce results). At
>least with Excel 97 the answer is no, you can't. They suggested writing
>a VBA function to mimic their random number generator where the seed
>could be reset.
>
>The details behind their random number generator is available for
>download from their website.
>
>Kirk
Sorry, I should write "the seed is randomized automatically" to express
exactly what I meant. Today was extremely hectic day :-)
Michael,
You wrote:
>How do you know? I have a need to be sure of this.
Sorry again. Kirk Fleming had already explained.
Arcady.
=============================================
Arcady A. Novosyolov, Ph.D.
19-149, Academgorodok, Krasnoyarsk, Russia, 660036,
tel. +7 3912 495382 (business), +7 3912 498596 (home)
fax (603) 688-4664 (U.S.A. number)
mailto: anov@cc.krascience.rssi.ru
Home page: http://www.geocities.com/CapeCanaveral/Launchpad/6016/
ICQ: http://www.icq.com/38856350
Visit the CAS Web Site at http://www.casact.org
===============================================
To subscribe or unsubscribe from CASNET:
Send an e-mail to caslists@lists.casact.org
Type in the body join casnet to subscribe
or leave casnet to unsubscribe.