Random Number Generator - Multiple, Non-repeating, results
Could, but it's much faster to calculate one number than to go through
the rest of the routine if the UDF is called from a single cell.
Won't be even the blink of an eye if there's only one call during a calc
cycle, but can add up if there are lots of multiple calls and multiple
iterations, and it adds only a few bytes to the code.
In article .com,
"Bernd" wrote:
Can't you just delete
"nCount = 1 Then
RandInt = CLng((nEnd - nStart) * Rnd() + nStart)
ElseIf"
in your randint UDF?
|