Setting a column of a 2D array = named range

S

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
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top