Hello Dear community,
I use following VBA to clear whole column if 1st row is blank.
It works perfectly fine.
Problem is I need it to delete no whole column. But from row 3 to row 60 and also from row 500 to row 1000.
Can anyone help me modify this code to achieve that ?
I use following VBA to clear whole column if 1st row is blank.
It works perfectly fine.
Problem is I need it to delete no whole column. But from row 3 to row 60 and also from row 500 to row 1000.
Can anyone help me modify this code to achieve that ?
VBA Code:
Sub Clear_Out()
Application.ScreenUpdating = False
Dim c As Range
For Each c In Range("F2:TY2")
If c.Value = xlnullstring Then
c.Resize(54, 1).Value = xlnullstring
End If
Next
Application.ScreenUpdating = True
End Sub