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.