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
Posted by Alan Vo to Alan Vo's deck (2015-03-20 04:35)
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