Unalterable Random Number

[howitt]

Does anyone know how use Index matching instead of copy and paste special to make the generated random number remain the same when we re open the sheet?

Thanks before!

Victor

 

[PHV]

To always get the same random numbers serie:
Rnd(-1): Randomize(1)
For i = 1 To 10
Debug.Print Rnd
Next

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[xlbo]

no - there is no formulaic way to achieve this. An Index/Match formula will return a result where it finds a match in a certain selection. However, that formula is 'live' and will change as often as the random number changes. The only way to get a function to stop calculating is to either turn calulation off or to turn it into a hardcoded number rather than a formula - and for that you would need paste special>values

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question