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
excel vba delete columns on another sheet
Sub sbVBS_To_Delete_Specific_Multiple_Columns() Sheets("Sheet1").Range("A:A,C:C,H:H,K:O,Q:U").EntireColumn.Delete End Sub
Source: analysistabs.com