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
Sub Combos()
Dim Total As Integer
Dim N1 As Integer
Dim N2 As Integer, Sum2 As Integer
Dim N3 As Integer, Sum3 As Integer
Dim N4 As Integer, Sum4 As Integer
Dim N5 As Integer, Sum5 As Integer
Dim N6 As Integer
Dim iRow As Long...
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.