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.
The full code was too long, had to delete some but changed the macro to make it work if you try to run it!![]()
Please Login or Register to view this content.
If it's just a simple character addition I'll be pretty darn satisfied![]()
Bookmarks