Inserting a new Column

[Eva_Johansson]

I want to insert a new columns in my worksheet somewhere in the middle of other columns using VBA through button click event
for instance I have columns from A to AC and now want to insert a new column just before AC and the new column will take the place of AC and actual AC would be move to AD and so on if there are other columns in the sheet?

Old sheet columns -> A, B, C, D....... up to AC
New sheet Columns -> A, B, C, D..... up to AC and AD ... and so on if existed (AC is the new column inserted) which happens to push the previous AC to AD and AD to AE and so on

The button is on the one workbook and inserting columns suppose to take place on the other worksheet of a workbook

Thanks for your help
BR
Eva

[Kaper]

Please Login or Register  to view this content.

in the button code shall do.