built excel function makes error 1004 in VBA

Question

I need to use statistic function in my VBA code but unfortunately error 1004 appears when I try to use built excel function.

My code:

Dim pValue() As Double
ReDim pValue(number - 1) 
For i = 0 To number - 1
    pValue(i) = WorksheetFunction.T_Inv_2T(Abs(StatT(i)), 17)
Next

And StatT Array consists of elements [10,82;-9,12;3,19]

Please help.

user3598756 · Accepted Answer · 2016-12-08 17:59:49Z

2

probability must be between 0 and 1:

    pValue(i) = WorksheetFunction.T_Inv_2T(Abs(StatT(i) * 0.01), 17)

answered Dec 8, 2016 at 17:59

user3598756

29.5k4 gold badges20 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

My god... I used wrong function... Anyway your answer solve the problem. Thank You :)