Hello everyone, I wonder if there is anyone who can help me please.



From a list of 10 names manually inserted in a spreadsheet I want to invoke a macro by pressing a button (I know how to do this bit). The macro will then randomly a number using the RANDBETWEEN function and highlight the corresponding name in the spreadsheet (this is the bit I don't know how to do).

Ideally I'd like the random selection to be relatively evenly spread across the 10 names but don't know if this is possible to control using a random function.

Attached Files

RECAP Project.xlsm (22.2 KB, 8 views)