Unfortunatly I cant get it right.

I want to run this macro 6 or 7 times, or loop back to second row and delete
those word until there is none.

thx.

Don Guillett wrote:
think about it.
cells(row,column)

I have Columns A:G and many cells I want to delete entire Rows if the
content
[quoted text clipped - 20 lines]
Next i
End Sub

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200707/1