Clear Cells that do not contain certain text

I have text in Col K

I want to clear all data in Col K where the first two characters is MJ or ZR

Please Login or Register  to view this content.

It would be appreciated if someone could kindly amend my code

Thanks for the help

When I run the macro, I get a run time error "Type mismatch" and the code below is highlighted

Please Login or Register  to view this content.

Kindly amend this section

Thanks for the help.


I want all items cleared where the first 2 characters in Col K from row 2 are not MJ or ZR

How about

Please Login or Register  to view this content.

If you want to clear col K only remove the line in blue, otherwise remove the line in red

Thanks for the help Fluff

Code works perfectly

Hi Arkadi


I replaced .entirerow.delete , with clear contents, but it clears first row

You're welcome & thanks for the feedback

Thanks for the help


Your code only clears header in 1st row

I would like all code cleared in Col K from row 2 onwards, the does NOT contain MJ and ZR in the 1st two characters in Col K

Thanks Arcadi

I have also added the following code to set autofilter off at end of code

Please Login or Register  to view this content.