View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Pit Pit is offline
external usenet poster
 
Posts: 1
Default Sorting players of cards


-----Original Message-----
put 1 to 80 in A1:A80

in B1 to B80 put in

=Rand()

then sort both columns with column B as the sort key.

now you can take the firs "n" cells.

Regards,
Tom Ogilvy


Ok but i need a random beetwen 1 to 80, any vba code?
Thanks in advance
Pit