automatically delete rows

[baby_gyrl61]

Hi there

I need to a macro that will automatically delete rows containing a sepecfic data.

Can anyone help?

Thanks!

 

[Trevor G]

Welcome to the forum,

Something like this will do the job.

<font face=Courier New><SPAN style="color:#00007F">Dim</SPAN> i <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Long</SPAN><br>For i = LastRow To 2 Step -1<br>  If Range("E" & i).Value = 0 Or IsEmpty(Range("E" & i).Value) Then<br>      Range("E" & i).EntireRow.Delete<br>  <SPAN style="color:#00007F">End</SPAN> If<br><SPAN style="color:#00007F">Next</SPAN> i</FONT>