Quote Originally Posted by TheRobster
What I actually want is the VBA equivalent of the worksheet RAND() function, but I need truly random numbers, not ones that are pre-determined by what came before!
Use RANDOMIZE once.

Next call to RND() has been seeded by RANDOMIZE to be a random number.

Then each RND() will return a random number based on a seed of the prior random number - which is pretty random wouldn't you agree??

That is as random as it gets.