Sort the range as an area

[dexiongmao]

Hello,
As shown in the images below, I want to sort a range alphabetically. I know how to sort them in rows or columns separately, but I don't know if range.sort can sort an "area".
The only solution I have in mind is to read every cell in range into array, sort array, then put the array to the original range. I am feeling there should be a quick method, or are there better ways than my idea?

Thank you very much.


Basically, given this range
1.png

I want it to be sorted like this
2.png

[AlphaFrog]

I don't know of a "quicker" method than the array method you described.

The built in Sort feature doesn't sort and area in one step as you requested. You could loop it for each column and row as below, but it wouldn't be any faster or more elegant than sorting an array.

Please Login or Register  to view this content.

An array sort would be my preference.

[kvsrinivasamurthy]

Here is the code for macro

Please Login or Register  to view this content.

[Marc L]

Hi !

The only solution I have in mind is to read every cell in range into array, sort array, then put the array to the original range.

It's a good idea, the sort can de done just using an Excel basics, just need an attachment to work on …

[dexiongmao]

Thank you all for your answers!

Here is my code after considering your suggestions, though I didn't use the actual concept of array. Instead, I put them in one column and used the built in Sort feature. Please let me know if there can be any improvements.

Please Login or Register  to view this content.