You would have to define your exact conditions, including what the TEXT is,
or where it may be found, and which rows relative to it's found location to
be deleted. Then a macro can be written to satisfy your requirements.

Vaya con Dios,
Chuck, CABGx3


"John" wrote:

need a macro, anyone know how to find a text in the worksheet and delete
range rows from the text it fund. sample: text in column A row 12, I want to
delete rows from rows 3-12 or text in rows 50, I want to delete from rows
50-58. pls help.