Unalterable Random Number

[m26498130]

Hi all,

Anyone know how to make the generated random number remain the same when we re-open the worksheet? Somebody once told me I could use Index Match function, but I have no idea how to implement it, please help me out!

Thanks before,

Manny.

[Ardus Petus]

Select numbers
Copy
Paste Special: Values

HTH
--
AP

"m26498130" <[email protected]> a écrit
dans le message de
news:[email protected]...
>
> Hi all,
>
> Anyone know how to make the generated random number remain the same
> when we re-open the worksheet? Somebody once told me I could use Index
> Match function, but I have no idea how to implement it, please help me
> out!
>
> Thanks before,
>
> Manny.
>
>
> --
> m26498130
> ------------------------------------------------------------------------
> m26498130's Profile:
http://www.excelforum.com/member.php...o&userid=33891
> View this thread: http://www.excelforum.com/showthread...hreadid=536719
>