Problem re-assigning array after a sort

[welchs101]

Hi,

I have an array where i read in the file names from a directory.

Note: When trying to run this macro create files with file names such as this
AA1_AA1_AA1_DET_owner.xls
AA2_AA2_AA2_DET_owner.xls
etc


The array used to store the file names has the format like this
file_array(1,1)
file_array(1,2)
file_array(1,3)
file_array(1,4)

file_array(2,1)
file_array(2,2)
file_array(2,3)
file_array(2,4)


I dont know if you call this a multi-dimensional array......not sure.

Anyway, i want to sort this array by the file_array(2, values.

So what i do is transpose the array , then paste into excel sheet, sort and then re-sort again and try to put back into arrray.

The re-transpose and trying to put back into the array is where i am having issues.

Its not doing it correctly.

Can someone help me? I have tried various things to no avail.