Quote Originally Posted by offthelip View Post
if you ensure that the cells D1 and E1 are not the same as the number in C1 , they are no longer random numbers. Is this what you want?
If so are you just going to recalculate until you gert on number which isn't the same or what?
To provide different random numbers ( which might end up the same) in cells D1 and E1 is so easy as to be trivial.
Randomize
Cells(currentrow, currentcolumn+2).value= rnd*7
Randomize
Cells(currentrow, currentcolumn+3).value= (rnd*7)+1
Randomize
Cells(currentrow, currentcolumn+4).value= (rnd*7)+2

To ensure the numbers are different you would need to enclose the second and third calculations in do while loops that check for difference to ext

I made a fatal mistake. Very Sorry and regret for any inconvenience caused. Actually the new requirement supposed to be Cell C1 should be a randomized number between 0 and 7. Cell D1 should be should show a randomized number between (greater than the value in Cell C1) and 8. Cell E1 should show a randomized number between (greater than the value in the Cell D1) and 9. This way it will not show any repeated numbers in any of the cells. All numbers should show as whole numbers.

Thanks.