Deke wrote:
Thanks, I works great, but for some reason it puts into a multi-dimensional
array...

If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook

ary = ArrayReshape(ary, 1, ArrayCount(ary)) will convert it to a 1-D array.

Alan Beban