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
Bookmarks