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.