Hi Mrinmoy, as far as I know you "can't go back"! Besides turning off automatic calculation (which I guess it's not very useful) the only solutions that comes to my mind are: (a) to use the Data / Data analysis / Random Number Generation to create an array of random constants or (b) to use a simple UDF in VBA to generate the random numbers.

The later approach could be:

Public Function randStatic()

Randomize Timer

randStatic = Rnd()

End Function

Just open the VBEditor (Alt+F11), insert a module in you workbook and paste the above code. The random numbers will be generated as if using the "Rand" worksheet function but the cell value will only change when inserting/pasting the "=randStatic()" function call or when editing the cell content. No change will occur when calculating, saving, opening etc.

Hope it helps, Luis

Pseudo-random number generators such as the Excel rand() functions are actually iterative arithmetic procedures, so one could reproduce a generated sequence if one knew the initial value, called the "seed" of the generator.

As far as I know, however, Excel does not let the user set the seed or retrieve it.

Hi all, by using VBA one can set the seed and also find the seed used previously (although time consuming and cumbersome). Kind regards

Thanks!

I forgot to mention earlier (wrt to the seed aspect, well pointed out by Silvio) that the Excel Analysis Toolpack add-in that is called when using the Data / Data analysis / Random Number Generation has the option to set the seed (see figure bellow). In VBA one sets the seed after the "Randomize" function (in the example I gave previously I used the Timer function as the seed). Regards Luis

Thanks for all the answer.I am trying the methods suggested and update about the results here.Thank you.