Delete the specific column which has less than -5 and 0

[Nandeesh]

Hi Everyone,

Can anyone let me know the macro to delete the specific cell which contains less than -5 and 0.

Thanks in advance.

Regards,
Nandeesh

 

[jolivanes]

Is this what you mean?
Change the Column references as required.
Try it on a copy of your workbook.

Sub Try_This()
    Dim c As Range
    For Each c In Range("B2:B" & Cells(Rows.Count, 2).End(xlUp).Row)    '<---- Change reference as required
        If c.Value < -5 Or c.Value = 0 Then c.ClearContents
    Next c
End Sub

 

[Nandeesh]

Thank you very much, this code work fine..