Thread: Random Number in VBA
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Random Number in VBA
=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


Reply With QuoteReply With Quote