Validation of 3 Unique Random selections

**BrianCob** · 05-22-2014, 02:28 AM

From an indexed list I need to select 3 unique names randomly. The index number is generated by a cell within the spreadsheet (Cell A1: =RANDBETWEEN(1,26) ); in actual application the “26” is not static.

The macro searches for the index number and records both it and the name to which it is indexed. The Selection and “?????” columns are there more for my verification except that, if the line: Range("G" & 4 + c).Value = Range("A1").Value is commented, after a time of repeatedly pressing the button the macro ‘freezes’ and Ctrl/Break produces a “91” error.

That is my first issue.
My second is: If my data does not begin in the second row (or my search does not begin from cell “B1”) then index 1 is seemingly never selected. Why?

I am confident that the macro will always generate three names successfully, but I need some assurance that my propositions about my two issues are correct.
That said, if there is a simple way, consistent with my given macro, that overcomes both issues then I’d be willing to be advised. Please.
Triple.jpg
Here is my macro:

Please Login or Register  to view this content.

**BrianCob** · 05-22-2014, 03:26 AM

I have attended to the request. Note that this is an example that would fit within an application.

**BrianCob** · 05-24-2014, 03:17 AM

Since my original posting I added some outer code to what is presented above. Its purpose was to run the sheet 10000 times but limit the 3 selections to just 6 possible choices. I don't believe that I need to present that code as I am confident that, after 10000 tests across such a small "population", it works.

I just want explanations for where I had doubts. "Why is it so?", to quote Julius Sumner Miller.