Microsoft Excel - Macro - Simple example that shows how to add columns

Watch this example on YouTube:

Sub InsertColumn()
    Range("C:D").EntireColumn.Insert
End Sub