Randbetween function embedded in a macro HELP
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.
|