Help with a macro!!

[seriouslystuck]

Hi All

Im really stuck at the minute! Im trying to write a macro that will look at a value in a cell then if another cell in the same row is blank then I want to delete that row.

EG: if E4 = "U22" and DW4 = "" then entirerow.delete I also need this to loop through until the last row.

I have copied a piece of code that I found online but I cant get it to work.

Any advice would be great.

Thanks

 

[VoG]

Try

Sub test()
Dim LR As Long, i As Long
LR = Range("E" & Rows.Count).End(xlUp).Row
For i = LR To 1 Step -1
    If Range("E" & i).Value = "U22" And Range("DW" & i).Value = "" Then Rows(i).Delete
Next i
End Sub