Simple Delete Row Question

[Parra]

Does anyone have a macro to delete a row if certain criteria is true?

I want to delete a row if Column G, contains the word "OK".

Thanks, I am sure one of you pros has the answer.

Parra

 

[bergy]

This similar question was answered earlier (I did a quick search).
Check out this link
http://www.mrexcel.com/board/viewtopic.php?topic=6309&forum=2

You'll have to make a couple of quick fixes

 

[Ricky Morris]

On 2002-04-25 11:52, Parra wrote:
Does anyone have a macro to delete a row if certain criteria is true?

I want to delete a row if Column G, contains the word "OK".

Thanks, I am sure one of you pros has the answer.

Parra

A non VBA solution:
Setup and use Filter to select the rows with "OK" in column G. Highlight the range with the "OK". Choose Edit > Delete Row.