View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TotallyConfused TotallyConfused is offline
external usenet poster
 
Posts: 144
Default Random Names and Command Button

I need to shuffle a list of names between rows 2 and 17. I also need a
command button so that when I click on button names will shuffle through
without duplicating or getting 0s. I tried Index Rand and RandBetween and
not being successful. Can someone please help me. I have seventeen names in
Column A. I want the sames names to be shuffled in column B. Thank you in
advance for any help.