Reorder columns by their letter (not column header)

[AnthoHead]

Is there a way to use VBA to reorganize columns by the column letter? I've looked through the forumn and found plenty of posts on how to do this by the header, but nothing by letter.

example:

I have a spreadsheet that goes to column GZ

I only need these columns and in this order- CQ,CP, A, B, C, D, J, K, R, V, W, X, Y, Z, AA, AB, AC, AN, AY, BE, BP, CB, GF, GW

Would this be possible? or do I have to use the header?

Also, I'd like to do this with code vs. recording the Macro. That way I can share with some Coworkers more easily.

 

[Michael M]

You could hide / delete the columns not required, but you can't "reorder" them.
Keep in mind deleting them will also, change their letter

 

[Rick Rothstein]

Is there a way to use VBA to reorganize columns by the column letter? I've looked through the forumn and found plenty of posts on how to do this by the header, but nothing by letter.

I have a spreadsheet that goes to column GZ

I only need these columns and in this order- CQ,CP, A, B, C, D, J, K, R, V, W, X, Y, Z, AA, AB, AC, AN, AY, BE, BP, CB, GF, GW

Would this be possible? or do I have to use the header?

Give the code I posted in my mini-blog article here a try...

<!-- title / author block -->Swapping (Rearranging) Multiple Columns of Data