Why not use RangeObj.Sort method to do the sorting? You are not sorting an
array, so I think a custom sort algorithm, like bubble sort, is not relevant
in your case.

Frederick Chow
Hong Kong.

"slim" wrote in message
...

Hey,

I have a large range of cells that I would like to be able to sort
descending by one of the columns.

Is it possible to do this using vba? I have looked into the bubblesort
technique but i can't get it to work and the version that i saw would
sort the whole worksheet rather than a range of cells.

Thanks in advance.


--
slim
------------------------------------------------------------------------
slim's Profile:
http://www.excelforum.com/member.php...o&userid=28643
View this thread: http://www.excelforum.com/showthread...hreadid=525357