Sorting not working properly

[EC37]

Hi. I need help troubleshooting this code I've written. I need the code to sort Column J, then sort column CH, then sort column Y. It appears to do this (to some degree, as the little up arrow appears next to the Filter in column J anyway), but not the way I need it to.

Manually, I would do just as I said above. Sort J ascending, then CH ascending, then Y Oldest to Newest. Here is how I have it written:

Please Login or Register  to view this content.

I wonder if it is sorting them all at the same time [somehow]? instead of sort 1, then sort 2, then sort 3.

Any help in troubleshooting this is really appreciated.

Thanks!
E

[shg]

The code sorts each column sequentially. If you want the analog of a three-way sort from the UI, reverse the order of the sorts.

[EC37]

Not sure I follow what you are saying. sorry, I don't know a ton about VBA, so you'll have to 'dumb it down' for me

I have a rather large table- columns A - CI. I want the whole table sorted by Column J. Then sorted by Column CH. Then sorted by Column Y.

The way I have it written- is it sorting the individual column rather than the column within the table?

[shg]

Not sure I follow what you are saying. sorry,

Suppose you select columns A:C and do a three-way sort via Data > Sort, sorting by col A, then B, then C. If you wanted to do the same thing using Autofilter's (sequential) sorting, you would need to sort by col C, then col B, then col A to get the same result. It's just how multi-level sorting works. Try it.

Have you tried recording a macro that gives you the correct sort order and comparing that to your code?