Randomize function

[tiredofit]

Following from Rick Rothstein's comment here:

https://www.mrexcel.com/forum/excel-questions/747715-rnd-not-truly-random.html

he suggests, if I understood him correctly, that you should only ever have the randomize function once.


In that case, why not just put it in the Workbook_Open event?

Thanks

 

[tiredofit]

I posted the message at that link before what shg posted was pointed out to me. His suggestion to use [=rand()] (which he posted later in the thread) to obtain a random number is the way to go within VBA code.

Thanks for clarifying.