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
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