View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd Bernd is offline
external usenet poster
 
Posts: 92
Default Random Number Generator - Multiple, Non-repeating, results

Hello,

Can't you just delete
"nCount = 1 Then
RandInt = CLng((nEnd - nStart) * Rnd() + nStart)
ElseIf"
in your randint UDF?

http://www.sulprobil.com/html/uniqrandint.html

Regards,
Bernd