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