Swapping (Rearranging) Multiple Columns of Data

[snb]

With your method, I would have to know where the column will end up at after the sort

I don't think so. It's meant to use the same method you use to indicate the order of the columns.

I also added a oneliner alternative in case the currentregion/usedrange doesn't consist of more than 26 columns.

[Rick Rothstein]

I don't think so. It's meant to use the same method you use to indicate the order of the columns.

Sorry, you are correct... we both are using the same method for delineating the order for the rearranged columns. I thought I had detected a "relationship" between our two posted "new order" example strings and responded based on that. I just tested your code and it works quite well also, although I would note your code requires the insertion and removal of a helper column to do its work (no big deal that, just pointing out a difference between our methods as it affects the sheet being processed). One personal observation... I really wish you would declare your variables (I use Option Explicit in all my procedures and had to disable it in order to stop the error it generates when testing your code).