VBA to Randomly Select a Cell

I have a list of people that I need to randomly assign to different tasks. Does anyone know how to do this? Here's what I have:

Please Login or Register  to view this content.

What I'm missing obviously is that there is no randomness yet.

This routine will pick at random all members of the range between 1 and rmax
the use of the array sel() is to ensure that the choices are not repeated.

Please Login or Register  to view this content.