tell excel: delete row if condition exists. possible?

[rllewis]

I want to tell excel to delete a row if a certain phrase occurs in a
cell in that row. Is that possible?

 

[Jim Gordon MVP]

Hi,

Yes, this can be done.

To do this create a macro using visual basic or ApppleScript that loops
through all of the cells in the row in question and looks for the string
of text. If it is found then the macro would delete the current row.

-Jim