Hi Marvin --
Thank you so much for your help! For part #1, I tried using your code with the InStr function (since the word I'm looking for is 'target2' embedded in a longer string), but I kept getting an error message saying Compile Error: Expected: Then or GoTo. I wasn't sure if I was supposed to leave the 'Exact Match' part in or not, but I tried it both ways and got the same error... Here's the two pieces of code I tried
I've uploaded the exact file I'm working with... You'll see the 'target2's in column B -- those are the rows I'm trying to delete...
MANY MANY thanks. I wish this was homework, since then I could just skip it, but instead its likely part of a thesis project! In theory I could do this manually, but have so many files that I'd develop carpal tunnel in the process...
Emily
Bookmarks