A search of the archives finds a number of potential solutions:

http://groups.google.com/advanced_gr...ugroup=*excel*

Including this post:

http://tinyurl.com/bl5hq

In article ,
"Pradip Jain" wrote:

want VBA code to generate random number with following distribution:
1. uniform: between two values
2. normal: mean and standard deviation is given

thanks
pradip