Think you mean

=Rand()

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

--
Regards,
Tom Ogilvy


"Gary''s Student" wrote in message
...
=Rnd()


"C. Roenbaugh" wrote:

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