Solved: Search for text as part of a cell

[Gunilla]

Hi
I need to find a text as a part of a cell and then delete that row. I know how to delete the row if I search for the exact text in a cell but not part of a cell.

:banghead:

[Bob Phillips]

Instead of



Id .Cells(i,"A").Value = "the text" Then

use



If Instr(.Cells(I, "A").Value, "the text") > 0 Then

[Gunilla]

Thank you, it helped me:beerchug: