Random Number in VBA

[C. Roenbaugh]

I need a random number generated in a UDF. I tried using
worksheetfunction.rand() without success. The number needs to be
uniformly distributed between 0 and 1. Any ideas?

Thanks

Chris Roenbaugh

 

[Tom Ogilvy]

Public Function MyFunc()
num = rnd
MyFunc = num
End Function

 

[Guest]

=Rnd()

 

[Tom Ogilvy]

Think you mean

=Rand()

But he appeared to be familiar with that since he was trying to use it in
VBA.

 

[C. Roenbaugh]

tHANKS