I'm a little confused with a sorting problem.

In a grid of numbers I want to sort row 1 ascending left to right, row 2 ascending left to right, row 3 ascending left to right and so on.

It's not really a list as the contents of any cell is not relevant to any other cell in that column. They are just individual rows each needing to be sorted.

I fear that I'm missing the obvious but what do I do and can I use a macro to do it all?

Thanks - Tonome