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

Yes,

Dim ary As Variant

ary = Range("myRange")

--

HTH

Bob

"SantaClaus" wrote in message
...
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

On 21 Giu, 18:32, "Bob Phillips" wrote:
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

I think you would need to load that manually then.

--

HTH

Bob

"SantaClaus" wrote in message
...
On 21 Giu, 18:32, "Bob Phillips" wrote:
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