Excel - Delete entire specified column using Macro/VBA

preview_player
Показать описание
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
Рекомендации по теме
Комментарии
Автор

what if i needed to delete more than 1000 columns ?

ElPunkero-udxc