Look again

http://www.rgn.hr/~dvulin/myerror.gif

P.S.

see the part bellow ;)



"Norman Jones" wrote in message
...

Hi Juggernath,



Try changing:



Dim A(11) As Double



to:



Dim A As Variant



---

Regards,

Norman





"Juggernath" wrote in message

...



"Norman Jones" wrote in message

...

Hi Juggernath,



As Bob suggests, the code worked in my test.



How did you dim your array?



"Norman Jones" wrote in message

...

Hi Juggernath,



One possibility:



Dim arr As Variant



arr = Array(1, 2, 4)



---

Regards,

Norman





Thanks for trying to help so far...



Here is my code (Custom function in VBA - excel - OfficeXP)



Dim A(11) As Double

A = Array(0.3265, -1.07, -0.5339, 0.01569, -0.05165, 0.5475,

-0.7361,

0.1844, 0.1056, 0.6134, 0.721)



and here is my error when i run a function using subroutine on a

given

picture

http://www.rgn.hr/~dvulin/myerror.gif



(i tried dim A(10) as double, and (1 to 11)...etc.)