Macro works too well.

Value I'm working with is " abc:", not"abc". Macro below won't work
with abc:.

I replaced abc: with abc in last six rows of worksheet and macro
worked. It deleted all rows.

I'm working on trying to fix it.

EJE



On Mon, 14 Aug 2006 07:23:53 -0600, "Dave Patrick"
wrote:

For r = 100 To 1 Step -1
If LCase(Trim(Cells(r, 2).Text)) = "abc" Then
Cells(r & "," & r).EntireRow.Delete
End If
Next