Excel - Delete entire specified column using Macro/VBA
Delete entire specified column using Macro
Sub deleteColumn()
Set a = Range("A1:B1")
For Each cell In a
If cell.Value = "Category" Then cell.EntireColumn.Delete
Next
End Sub
Delete entire specified column using Macro
Sub deleteColumn()
Set a = Range("A1:B1")
For Each cell In a
If cell.Value = "Category" Then cell.EntireColumn.Delete
Next
End Sub