If you read the range into an array in a variant, it's always a 2-dim array,
even though it may have only one row or one column.

There's no comman. You have to use a loop for this.


On Thu, 29 Jul 2004 15:49:45 -0700, "DavidMatthews"
wrote:


How do I assign a 10 row x 1 column range to the 2nd column of a 10 row x 3
column array, in VBA?

(looking for something similar to:

My3ColAry(*,2) = My1ColAry(*)

Is there a command that does this? Do I need to do a loop for each element?
Thank you very much if you can help.