VBA For / Do While Loop

Hey all,

I've created a macro that will generate 3 random numbers from column A into column C.

However, I would like add a condition(s) to make sure that these 3 random numbers are not in Column B and have no been selected previously. If either of these conditioons are met, then a new random number is to be chosen.

I'm sure there is a 'Do While' loop of some sort, but can't get it working. My (current) working code is below and as attached.

Please Login or Register  to view this content.

Perfect exactly what I was trying to do. I wasn't intending to have the range between 2 and 23. Where abouts in the equation I'm I modifying?

Formula:

Please Login or Register  to view this content.

That easy?

@DHHM & @Pauley

I test the code provide by Pauley & found an error.

To test the code I copy first ten numbers from column A to column B.
In column C I used

Formula:

Please Login or Register  to view this content.

I have attached image file, plz check the yellow color cell is common in all three columns.

Let me know if I am missing anything.

Regards,
AM

thats cause he only checks the first 3 rows for a duplicate

change the Red number to fit your needs and the could should work perfectly

Please Login or Register  to view this content.

greets
Loki

Originally Posted by LordLoki

thats cause he only checks the first 3 rows for a duplicate

change the Red number to fit your needs and the could should work perfectly

Please Login or Register  to view this content.

greets
Loki

Thanks Loki

Thanks all.