Random number generation loop for a range of cells until condition is true!

[gychoo]

Hey guys,

I really tried to come up with my own solution by combining knowledge from answers to different posts, but being a total noob that I am...I just couldn't do it!

So here is what i'm trying to do.

1. [Do] From cell C1 to cell C30, I would like VBA to generate random results from two choices (my current excel function looks like this --> =INDEX({"G","B"},RANDBETWEEN(1,2))

2. [Until] until cell D30 reads "Yes" (D30 contains some function based on the result of cell C1 through cell C30 and some other cells)


so that, if a set of randomly chosen values of C1 to C30 doesn't return a "yes" in D30, it starts the whole process all over again. of course until D30 reads "Yes"

Thanks so much in advance guys!

[mehmetcik]

Please Login or Register  to view this content.

[gychoo]

Thanks so much! I just have one quick followup question!

Right now, the loop does stop when it sees "Yes" in D30, but the randbetween seems to run an extra loop after that....so the end result has changed due to that extra loop and D30 no longer reads "Yes".

Maybe this has to do with the way randbetween works? is there a way to fix this so that when the loop stops, I see the actual results that stopped the loop?

[gychoo]

Never mind!

I was able to stop the loop from doing an extra loop by removing

Application.Calculation = xlCalculationAutomatic

Thanks so much for your help mehmetcik!