Multi level sorting - line continuation limit

this is going to crash excel, my man. not good. you need a database, seriously. why do you have 2000 cols of data!? wow. but, if you want to attempt it, use the macro recorder, do the sorting of 2 cols through the interface by clicking buttons, look at the code, see the iterative and pattern of key integer counting the program does, and any other relevant issues, then copy it 1998 more times. done. if you need to produce the code by automation, copy the 2 lines of VBA code excel gives you into 2 rows in col a, then parse the data out to many diff cols, and use the autofill handle to drag down 1998 more rows to get what you need, then concat the data from all the parsed cols back into a new col. then copy all 2000 lines of code in the new col to the VBA editor. finished.

1)
Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

2) Line continuation?
You can use that sort method by 3 columns at a time, so you will need to loop from less priority column(s) to higher.