Call sub with array
Hi Arne,
Give this a try.
Change your function declaration to become like this:
Function SortArray(ByVal TheArray As Variant) as Variant
Then, before the "End Function" line, put this line:
SortArray = TheArray
To use your new function, you do something like this
A = SortArray(A)
basel = A(2)
--
Hope that helps.
Vergel Adriano
"Arne Hegefors" wrote:
Hi! I have a problem with an array that I have in a udf. I send the array to
another udf in order to sort the array. Somewhere there it goes wrong and the
code stops.
€¦€¦
Call SortArray(A)
basel = A(2)
End Function
€¦..
Function SortArray(ByRef TheArray As Variant)
Sorted = False
Do While Not Sorted
Sorted = True
For X = 1 To UBound(TheArray)
If TheArray(X) TheArray(X + 1) Then
Temp = TheArray(X + 1)
TheArray(X + 1) = TheArray(X)
TheArray(X) = Temp
Sorted = False
End If
Next X
Loop
End Function
The sorting seems to work just fine but the code never goes back to the line
basel = A(2). Instead it goes back to the line before the Call SortArray. I
have no idea what is wrong. Please if anyone can help me! Thanks a lot!
|