ReDim array inside nested loops

Hi Don,

Originally Posted by xlnitwit

Hi,
_....the array only has one row, transposing will produce a 1 dimensional array, not 2D.

If an Array has only one "row" , ( I think ) , .Transposing will produce a 2 D, 1 "column" Array.

If an Array has only one "column" , ( I think ) , .Transposing will produce a 1 D Array.

( At least that is the results that I usually get )

Norie's code does the building of the Array transposed to allow Re Dim Preserve to be used. So in the case of the OP having one row, the Array that Norie's code builds has 1 "column". This then , on the .Transose , returns a 1 D Array

Alan