Macro for sorting numbers ?

[HighlandMick]

HI

I have used Data|sort to sort numbers in one row, but when I select multiple rows, it still only sorts one row.

Do I need a macro to sort all the data in my sheet ? or is there a way to do the whole sheet using Data|sort manually ?


Michael

[shg]

You need to select all the data you want to stay together before sorting.

Then you can sort by rows or columns; see the Option button in the Sort dialog.