I was looking thru some Excel files that a former employee left. This code was used to generate a list of non-duplicated random numbers, according to the parameters entered. I ran it a few (like 100) times, but it never seems to give me "low" results, i.e., lower = 1, upper = 10000, number = 500 and it never returns a random number less than 100. I can't seem to figure where the error is. I know that it IS possible to not generate a number below 100 on occasion, but when running it repeatedly?

Please Login or Register  to view this content.