In Excel VBA, can I assign a whole column or a whole range of a two-
dimensional array directly, to be equal to a named range?

For example, MyArray(3,5) = x assigns x to the 3rd row and 5th column
of MyArray.

But let's say I have a named range of size 1 x 8. Can I set the whole
3rd row of MyArray to be = MynamedRange ?
If yes, how? Something like MyArray(3,1 to 8) = MyNamedRange or
MyArray(3, ) = MyNamedRange - which of course don't work :(

Thanks for your help. I searched forums and the web extensively but
couldn't find anything useful