VBA Macro to generate groups of 3 random numbers without repetition

The following VBA Macro generating repeated numbers.

Please Login or Register  to view this content.

Option 1 (which is preferred). Cells C1, D1 and E1 should show randomized Integer number between 0 and 9. Cells C1, D1 and D1 should NOT show same(repeated) numbers. This should continue all the way to Cells C1440, D1440 and E1440 where Cells C1440, D1440 and E1440 should NOT show same (repeated) numbers.

Alternatively, Option 2. 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. This continue all the way to Cells C1440, D1440 and E1440 where Cells C1440,D1440 and E1440 should not repeated(same) numbers.

Your help will be greatly appreciated.

Thanks.

Hi Jeff. Thanks for your help.

My VBA programme was written for the Option 2. I tried your version and guess what it worked fine.

Please Login or Register  to view this content.

So I made some changes as

Please Login or Register  to view this content.

Now I want to modify the programme even further. Now instead of getting a random number between 0 and 9, I would like to get in between 1 and 9.

How should I change the programme accordingly?

Thanks and Regards.

Hi Jindon,

I truly appreciate your help.

Thanks and Regards

You want a range of 1-9, so that is a scale of 8. Applying a scale of 8 gets you to 0-8, then you need to add 1.

Int(Rnd * 8) + 1