How to swap places 2 excel columns

Hey everyone,

Have a real simple problem here.

I want to swap the places of column A and B.
So A will be B, and B will be A (headers will be swapped as well so I wanna swap everything in those columns)

Ty in advance

Hey berkaykor

3 months ago I’ve made a LinkedIn video solving your question. Check this:

Kind regards, Anders

Thank you very much it works.

Could I change the position of 2 columns using invoke method 1 time? or do i have to make 1 invoke method for each.