vba delete column code example

Example 1: vba excel delete column

' Deletes 3rd column
ThisWorkbook.Worksheets(1).Columns(3).EntireColumn.Delete

' Deletes 3rd column of a range
Range("My_RANGE").Columns(3).EntireColumn.Delete

Example 2: excel vba delete columns in range

' Deletes 3rd column
ThisWorkbook.Worksheets(1).Columns(3).EntireColumn.Delete

' Deletes 3rd column in range
Range("My_RANGE").Columns(3).EntireColumn.Delete