Reposition Columns

This should do

Please Login or Register  to view this content.

Then need to Cut/Paste...

Please Login or Register  to view this content.

Hi jindon,

Amazing, works perfectly... So I can understand it fully can you explain...

Please Login or Register  to view this content.

as I need to try and apply this to my main much much larger sheet. I'm trying to fuigure out how ("4,5",2), Array(7,6) relate to the specific columns, and why the 4,5 have "" around the numbers.

Basically I'm trying to understand where and which numbers go where based on the coulmns I need to move. It made sense on the first version but now I'm slightly confused by the logic.

Many thanks

Hi Sweep,

Yes, this works well too...

Many thanks

Please Login or Register  to view this content.

e holds Array("4,5", 2) and Array(7, 6) as it loops

Please Login or Register  to view this content.

e(0) = "4,5" and 7 respectively (1st element of the array)
e(1) = 2 and 6 (2nd element of the array)

You want column 5 & 4 to be inserted in column 2 and column 7 to be inserted in column 6.

HTH

So my real world example, attached (again slightly simplified, as there are around 80 columns, but no columns to the right of these need to move).

I need to move columns 2,3,4 and 10, to column 19, so I'd assumed I'd go

Please Login or Register  to view this content.

but firstly it only moves columns 2 and 3 and misses out 4 then what is column 10, which becomes column 7 after 2, 3 & 4 have moved ends up in the wrong place. What am I doing wrong?

Many thanks

In that case.... one way

Please Login or Register  to view this content.

Hi jindon,

Okay, that moves the columns to the correct position but then you have to run the macro 41 times to reset them back to their original positions, is it possible for this to be a toggle, run once to move columns, run again to reset them back to their original positions?

Many thanks

Toggle...

Please Login or Register  to view this content.

Hi jindon,

Works perfectly, I love the simplicity of the code, I just wish I understood it a little better. I need to spend some time understanding the logic as VBA isn't my strong point.

Many thanks for your elegant solution, greatly appreciate the time you've taken over this...