Hi there,
below is the code i use to get NormInv. The error i am getting is "Unable to get the NormInv property of the WorkSheet class.
Please help.
Sub NOrmInv()
Dim mean , StdDev as double
dblRandom = WorksheetFunction.NormInv(RandomNumbers, mean, StdDev)
end sub
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.