Learing about Range Objects

Originally Posted by romperstomper

Why do you want an array of column indices?

Hi Rory,
. Bit of a long story: ( hey that rhymes nice...)
http://www.excelforum.com/excel-new-...ba-arrays.html

....".......quick “One Liner” at producing an Output Array derived from an Input Array using a code line of this form

arrOut() = Application.Index(arrIn(), rws(), clms())


where the Arrays rws() and clms() contain a list of "row" and "column" Indices of the rows and columns in the Input Array required in the Output Array. ...."........