ClearContents if Cell Contains Certain Text String

Hello all,

The following code clears the rows if it contains the textstring "POS" in Range F2:F15
I'd like it to do the opposite (clearing the cells that do not contain the textstring "POS")
And rather than clearing the row I'd like it to clear the cell only.

All help is welcome

Please Login or Register  to view this content.

Hi,

should be easier with a filter and using SpecialCells method …

Jonathan,
Your existing code finds the match ONLY. There is NO find next built-in the code. This code does the opposite, but as suggested by Marc, Filter is simple and faster code than loop.

Please Login or Register  to view this content.

Thanks guys!