MamboKing
07-01-2008, 10:42 AM
Function NewVector() As Double()
Dim Vector(10) As Double 'Or any size but MUST be double
...
...
NewVector = Vector
End Function
Problem:
Excel does not display the Function results (through the regular area selection and Ctrl-Shft-Enter).
It comes out with the error #VALUE! in every selected cell.
If I change the Function type to Variant the compiler says "cannot assign to array" (it means the Function).
I cannot change the Vector type. Must be Double.
Any hint, please...? Thanks!
Dim Vector(10) As Double 'Or any size but MUST be double
...
...
NewVector = Vector
End Function
Problem:
Excel does not display the Function results (through the regular area selection and Ctrl-Shft-Enter).
It comes out with the error #VALUE! in every selected cell.
If I change the Function type to Variant the compiler says "cannot assign to array" (it means the Function).
I cannot change the Vector type. Must be Double.
Any hint, please...? Thanks!