View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Robert Reid Robert Reid is offline
external usenet poster
 
Posts: 6
Default VBA module/function to generate random numbers with specified mean and SD

BTW - the generated numbers have to be = 0 (positive numbers)


"Robert Reid" wrote in message
...
Hi all,

As basis for a school assignment I need to generate 20 random numbers that
have a prespecified mean and standard deviation ( I don't believe they
have to be normally distrubted).

Can anyone help?

The output would preferably be to Worksheets("Sheet1").Range("A1:A20")
though an array would also work.

Thanks.