Use of Variants

I was thinking a UDF

Function myArray(myRange as Range) as Variant
  myArray = Application.Transpose(myRange.Column(1).Value)
End Function

or

Function CountingNumbers1to(N as Long) as Variant
    Dim i as Long, resultArray() as Long
    ReDim resultArray(1 to N)
    For i = 1 to N
        resultArray(i) = i
    Next i
    CountingNumbers1to = resultArray
End Function

That last UDF runs into some differences between Mac VBA and Windows VBA, but Variant is the required type for a Mac. (VBA v.5 instead of v.6 ?? )

That is the part of the difference.
That statement will give an "Expected: end of statement error" to a Mac.
Also, this will work on Windows:

Dim oneArray(1 to 3) as Long
Dim two Array() as Long
For i = 1 to 3
    oneArray(i) = i
Next i
twoArray = oneArray:Rem potential error line

but gives a Mac a "Can't assign to array" error. The fix:

Dim twoArray as Variant

Thank you for all the answers.
Certainly helps.
Last additonal question. have you ever seen that the typecast failed, e.g. for MMult, Cint(), SumProduct, ... Functions?