You will still need to sort the range before it is concatenated. If you need
to leave the dataset intact, then make a copy of the range, sort the copy,
concatenate the sorted copy and then delete the sorted copy.

Mike F
"Greg" wrote in message
oups.com...
Hi Toppers,

I can't realy sort the cells in the range I think, they form part of a
matrix. I think sorting them will stuff up the matrix.