View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pino pino is offline
external usenet poster
 
Posts: 2
Default help again function vectorfunction

I dont understand the help ...............ParamArray intScores() As
Variant)...
How do you modify this example that...doesnt work :-(

Here, the function thirdsecond_pow does not work
Can you help me more?

thanks a lot!

Option Base 1
Function thirdsecond_pow(s As Variant)


Dim w(), q()
n = s.Rows.Count


ReDim w(n, 1), q(n, 1)


q = second_pow(s)
w = third_pow(q)


thirdsecond_pow = w


End Function


Function second_pow(s As Variant)


Dim w()
n = s.Rows.Count
ReDim w(n, 1)


For i = 1 To n
w(i, 1) = s(i) ^ 2
Next i


second_pow = w


End Function


Function third_pow(s As Variant)


Dim w()
n = s.Rows.Count


ReDim w(n, 1)
For i = 1 To n
w(i, 1) = s(i) ^ 3
Next i


third_pow = w


End Function


thank you