Setting a column of a 2D array = named range

[SantaClaus]

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

 

[Bob Phillips]

Yes,

Dim ary As Variant

ary = Range("myRange")

 

[SantaClaus]

Yes,

Dim ary As Variant

ary = Range("myRange")

Thanks, but I'm not sure that's what I meant.
I want ary to be, say, a 5x8 array, and I want only one raw of ary to
be = Range(myRange"), whereas I understand your code sets the whole of
ary = to the range

 

[Bob Phillips]

I think you would need to load that manually then.