How to sort values in a row by using Array method

Hi All,

I have a rate list in some columns, and I want to sort the rate in ascending order as per the rows (row wise), so the highest rate should be in column A and the lowest rate will be in the last column.

Please let me know how can I assign Array (ReDim) on it or then do a bubble or quick sort or anything the best method.

Please note, the count of columns and rows can be increased or decreased in other files.

Thanks !
SunOffice

Please Login or Register  to view this content.

Hi, SunOffice,

just for curiosity: what´s wrong with the normal Sort routine which could sort on Columms as well that you would need an Array to do the job?

Ciao,
Holger

Thank you nilem!
Your method is very good and simple to understand, ...I like it!

Thank you jindon!
This is somewhat I was also looking for the advanced level learning.

Hi patel45 ==>> Thank you for the help! I was looking for the sorting of Arrays by ascending and descending methods, and would also like you to explain the method/trick for your line " ' now you can use arr for sorting".

Hi HaHoBe ==>> Thank you for the idea! Actually there are two reasons - 1st) I did find the any way to sort on column values, which is already in Excel's data tab menu. 2nd) I am keen to learn the advanced trick of sorting Arrays.

With Regards,
SunOffice