NormInv property of the Worksheet.

[bontle01]

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

 

[stefen054]

Hi

Check ur code follows the rule.

NORMINV(p, mu, sigma)

where p, mu, and sigma are numeric values. Because p corresponds to a probability (see note 1), it must be greater than 0 and less than 1. Because sigma represents
standard deviation it must be greater than 0.

http://support.microsoft.com/kb/827358

Regards,
Durai

 

[bontle01]

Thanks,

Even if p>0, the problem is that the code does not recognise NormINv.

Masese

 

[PHV]

Have you tried this ?
dblRandom = Application.WorksheetFunction.NormInv(RandomNumbers, mean, StdDev)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[bontle01]

yes, i did and it does not work.

Masese

 

[combo]

Check the rest of your code. The error indicates that somewhere you try to get NormInv from WorkSheet instead of WorkSheetFunction class.
You could try to display all parameter values you try to pass to NormInv.
Try to compile the project.

combo