Randy -

In the most recent versions of Excel, the worksheet functions RAND and
NORMINV have better numerical properties.

So, you could use =NORMINV(RAND(),Mean,StDev) to obtain dynamic normally
distributed values on a worksheet.

Or, in VBA, use RND instead of RAND, with WorksheetFunction.NormInv.

- Mike

www.mikemiddleton.com