How to convert a 1 by N array intoa one-dimensional array of length N?

[JenniferMurphy]

When I load a VBA array from a range like A5:J5, I get a 1x10 array. It's a bit of a nuisance to have to always include that extra dimension (Arr(1,i)) rather than just Arr(i).

Is there a simple way to convert it from 1x10 to just 10 without a loop?

Thanks

 

[JenniferMurphy]

Just use one Transpose for a single column.

Got it. Thanks.