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.

Loops are required, but they are built-in in the functions in the freely
downloadable file at http://home.pacbell.net/beban:

ReplaceSubArray My3ColAry, My1ColAry, 1, 2

Alan Beban