Assist in modifying code to locate an exact phrase in a cell

[Jsin]

Hello, I need help with the below code to find exactly what's listed. Right now if it finds that in any cell in the row it deletes the row (which worked wonderfully for what I needed it to do before). I need to make it find the exact phrase. Usually it's located in column A, once in a while it may be in column B.

If a sample sheet is needed please advise. It'll take me some time to 'clean up' the data for public posting.

Edit! - What happens is we have locations such as "A-A-0" and "NA-A-0". I need this code to find just the A-A-0 one and not delete the NA location too.

Please Login or Register  to view this content.

The full code was too long, had to delete some but changed the macro to make it work if you try to run it!

If it's just a simple character addition I'll be pretty darn satisfied

[Jsin]

My mistake, hopefully the edited title works for the forum rules. I should have known better than to use generalized titles anyway!

[shg]

Maybe like this:

Please Login or Register  to view this content.

[Jsin]

Hello, the code almost works correctly. It seems to miss some of the ones that are in the front or back of a row (eg. Misses L-A-0 sometimes) any advise? There are other ones that it missed, but it always is in the front or back of the rows like below...

Please Login or Register  to view this content.

[shg]

There should be a comma in the text string at the end of each line, as corrected in my prior example.

[Jsin]

That did the trick. Thank you very much for the bit of code and your follow up so much later.