Jag Man wrote:
.. . .The
upshot is that (a) Only Variants can
be used to move data to/from ranges . . . .

From yes, to no. The following works:

Sub testIt()
Dim arr(3) As Long
arr(1) = 1
arr(2) = 2
arr(3) = 3
Range("A1:C1").Value = arr
End Sub

Alan Beban