If you plan to use the code you posted, you will need to add a Randomize statement to it (by the way, you have two other code solutions that do not require this); otherwise, when you close the workbook and then reopen it at a later date, your code will generate the same exact "random numbers" as it did the first time you used your code. To do this, just put the word Randomize on a line all by itself near the beginning of your code (after the last Dim statement would work).