Hi, I got the below code by searching online. I would like to delete columns based on a range of cells E12 to I12. If any of the cells are empty, then only that column should delete. The code only deletes one column at a time. Your help is appreciated.
VBA Code:
Sub Macro1()
Dim rngCell As Range
For Each rngCell In Range("I12:E12").Cells
If rngCell.Value = "" Then
rngCell.EntireColumn.Delete
End If
Next
End Sub