Hello,
I have this piece of code that should delete an entire row according to some cell value.
The code just goes through and does nothing any help would be appreciated.Sub user_prep() Dim newDtop As Long Dim newDbot As Long Dim Entry As Range newDtop = [A1].End(xlDown).Offset(2, 0).Row newDbot = Range("A" & Rows.Count).End(xlUp).Row For Each Entry In Range(Cells(newDtop, 1), Cells(newDbot, 1)) If LCase(Entry.Offset(, 9).Value) = "NULL" Then Entry.EntireRow.Delete End If Next Entry End Sub
Bookmarks