Excel delete columns which headers contain "offer"

Posted . Visible to the public.

Sub remove_columns()
For i = ActiveSheet.Columns.Count To 1 Step -1
If InStr(1, Cells(1, i), "offer") Then Columns(i).EntireColumn.Delete
Next i
End Sub

Alan Vo
Posted by Alan Vo to Alan Vo's deck (2015-03-20 04:35)