I think I'm close to a workable solution now. The function  is
assigned the value of the output array but the user  must select the
destination range  and press <ctrl><Shift><Enter> when entering the
formula.

For instance:

Public Function myFunction()
Dim arr(1, 0)
arr(0, 0) = 3.14159
arr(1, 0) = 2222
myFunction = arr
End Function

Will output the correct result table.