VBA results upside down

[YanAK]

Hi good ppl,
I've created a VBA function that returns an array as result
something like that

my question is, is there any worksheet function that can flip the result? so it's 1,251 will be the first row and 665 second and so on.
Ooh and note that i'm already using Trasnpose function, so I can have vertical result instead of horizontal.

Thank you.

 

[steve the fish]

Do you mean you want a formula or do you mean you want to get the reverse result from the function?

 

[YanAK]

reve

Do you mean you want a formula or do you mean you want to get the reverse result from the function?

reverse it from the function

 

[YanAK]

I can paste the code, but it a bit long.

 

[steve the fish]

Its easy to spin an array by creating another of same dimensions and looping bottom to top from the original. Heres an easy to understand way:

Dim arr, arr2, i As Long, a As Long

arr = Array(1, 2, 3, 4, 5)
ReDim arr2(0 To UBound(arr))

For i = UBound(arr) To LBound(arr) Step -1
    arr2(a) = arr(i)
    a = a + 1
Next