I was treating the code as two separate macros. Got it working now
perfectly. Thanks for your help.

"Ron Rosenfeld" wrote in message
...
On Sun, 26 Jun 2011 13:38:16 +0100, "wulfit"
wrote:

Thanks for that. Both macros are almost working - when I run them I'm
getting an error message "Compile error: Sub or Function not defined" -
referring to SingleBubbleSort. I'm sure this is fairly easy to fix but I
don't have enough knowlege yet about VB to do that.

If you copied and pasted the macros as I posted, you should only need to
select cells and run SortCell

You should only be getting that error message if you did not copy the full
macro, which is everything between the two double lines.