insert column via macro

[1excellentexcel]

I am having two issues with how to insert a column. First is there is a centered merge cell above the column, second where I want to do the insert and copy paste is not at the end. Please see the below. So the "Last 5 days" is center merged over the last 5 days cells of Sept 10th - Sept 16th. What I need the macro to is essentially insert a column between the 15th and 16th and hard code the 16th into the new column. then hide the Sept 10th column. please help. Thanks

[TABLE="class: cms_table, width: 452"]
<tbody>[TR]
[TD="colspan: 5"]Last 5 Days[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10-Sep[/TD]
[TD]11-Sep[/TD]
[TD]12-Sep[/TD]
[TD]15-Sep[/TD]
[TD]16-Sep[/TD]
[TD][/TD]
[TD]∆ DOD[/TD]
[TD]∆ QTD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]