Thanks for the quick reply. I tested what you wrote but as expected it only sorts on the coloumn and not accross the rows, eg.

from 15.30 10.40 2.10 7.40 etc
to 2.10 7.40 10.40 15.30 etc

This is what I am need . Single row at a time can do but many rows at once approx 6,000 cannot do. Maybe to hard for excell.

Thanks i advance. Ray.