Hi
you have to add a reference to the Analysis Toolpak add-in for this

--
Regards
Frank Kabel
Frankfurt, Germany

"miong" schrieb im Newsbeitrag
...
Hi,

I am working on a simulation project in Excel/VBA and
need to generate normal random variables by function
Norminv. The compiler doesn't know this function. I guess
that I have to select/add a certain Add-In to activate
this function. Does anyone know which Add-In or how to
use this function in VBA?

Thanks

Ming