I am having some doubts over the VBA "Rnd" function about if it really generates a random number (between 0 and 1). Does this mean that after the first random number is generated, this is used as the seed for the next one and that the number sequence from then on is pre-determined. 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. So if I have the following code:
Does that generate 1,000 truly random numbers or will they be in a pre-determined sequence.HTML Code:Let i = 1 to 1000 Range("A1") = Rnd next i
Bookmarks