Example - Below code will add a new column at B. Old data at column B will be shifted to right.
activeworksheet.Columns(“B:B”).Select
Selection.Insert
To delete the data in column B, just use delete method.
This is how we can add column at any position in excel using macro.
activeworksheet.Columns(“B:B”).Select
Selection.Insert
To delete the data in column B, just use delete method.
This is how we can add column at any position in excel using macro.
No comments:
Post a Comment