Delete all cell content in column except for desired string

Hello all, having troubles here and can't find an answer to help in the forum.

I have a code here that I want to cycle through all values in column E. If the value in column E is anything other than 'Volunteer & Internship' I want to clear the cell content. I have tried various codes, but here is the last. I keep getting a mismatch error for this one and don't know where the mismatch is. Maybe it is more than just that error too, not sure. This is what I have, anyone able to correct me?

Please Login or Register  to view this content.

Sorry, I don't really know if I understand what the code you offered is doing... It doesn't seem to specify anywhere that this should be done in Column E and that the cell content in column E only is to be cleared if it doesn't have 'Volunteer & Internship'. Could you please explain? Thanks.

Thank you for explaining. I know understand what it is doing and got it to work!

Okay, so here is another question pertaining to this, because I can't seem to get it to work. Can you ask for it to look for two different strings 'volunteer & internship' or 'Adventure & Culture' and then clear any cells that do not have one or the other?

I put the following and now it clears everything. Why?

Please Login or Register  to view this content.

Scratch that, thought about it and put in 'and' instead and it solved the problem.