Inserting columns

[tharindudk]

Hi,

I am trying to copy Column D to next column everytime I click a button.
I have a small template in Column D. So when I click the buton this template get copied to Column E after creating a New column.

however what I want to do is, paste the template after the previously inserted column. so that everything will be in order.

Eg. first time I click the button, template will get copied, I label it as Order1, second time i click it template will get copied and it should be inserted after Order 1 so i can name it as order 2. so it goes like 1, 2, 3, 4. at the moment its 4,3,2,1.

This is the code i am using

Please Login or Register  to view this content.

Any help is much appriciated

[GC Excel]

Hello,
Try this code :

Please Login or Register  to view this content.