Hello,

I have written Excel Function which returns an array:

Public Function dummy() As Variant
Dim arr As Variant

arr = Array(10, 20, 30)

dummy = arr
End Function

Now, I want to use my function in Excel but I want it to set the array
elements vertically in the cells. For instance if I am in the Cells(1,
1) and write
=dummy()
I am expecting to see
10
20
30
respectively in Cells(1, 1), Cells(1, 2), Cells(1, 3)
it will be greatfully appreciated if you have a solution for it.
Thanks,