Looks good to me.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Ed" wrote:
| Thank you sir for your patience. I have the macro running exactly the
| way I want it to. No problem deleting the rows with abc:
|
| In addition to rows with abc: there were blank rows to be deleted
| also.
|
| I did have trouble with your exact coding so having a little
| knowledge, I modified the code to the following:
|
|
|
| For r = 122 To 1 Step -1
| If Cells(r, 2).Text = "abc:" Or Cells(r, 2) = "" Then
| Rows(r).EntireRow.Delete
| End If
| Next
|
|
| The original table had 122 rows. Deleting abc: and blank rows left me
| with 59 rows to manipulate.
|
| I do appreciate all your help.
|
| What do you think of my simplification of the code?
|
| Thanks again,
|
| Ed English