sorting an array

Dear all,

Does anyone know a fast way to sort the rows of a 2-dim array (in descending order) by a particular column. For example, suppose I've got the following array

V W X Y Z (the column names)
----------------------------------
a1 a2 a3 a4 a5
b1 b2 b3 b4 b5
c1 c2 c3 c4 c5
d1 d2 d3 d4 d5

I want to sort this array by variable Y. Let's suppose c4>a4>d4>b4
Thus, I want back

c1 c2 c3 c4 c5
a1 a2 a3 a4 a5
d1 d2 d3 d4 d5
b1 b2 b3 b4 b5

I have a big 2-d array, so something fast would be really helpful. Can anyone help with this problem?

Thanks in advance.

Regards,
John

Like this:

Please Login or Register  to view this content.

See VBA Help for the Sort method

Thanks. But the data isn't contained in the worksheet. It is manipulated and created in VBA itself. Was looking for a sub-routine to do this.

mikerickson, that's a self-referential link ...