ClearContent Based on Contents Matching

[nigelld]

I thought this would be quite simple to solve and have been searching through Google since yesterday but still not managed to resolve it. I've come close but not managed it.
I have a column with various values in, string and numeric. The strings I want to keep have "," in and letters one side and "space" on the other. All the cells I want cleared do not have ","
The rest of what I'm using works fine accept this line which forces an error. Please could someone help me with it. Thank you in anticipation.

Please Login or Register  to view this content.

[Mumps1]

Try:

Please Login or Register  to view this content.

[stnkynts]

Try:

Please Login or Register  to view this content.

[nigelld]

Hi Thanks for the suggestions. Unfortunately both come up with a 'Runtime 1009' error.
The full code I have is below. It may not be the most efficient but this is a one time use situation.

Please Login or Register  to view this content.

[mikerickson]

Is it possible that some of the cells have error values (e.g. #DIV/0)?
If so, try

Please Login or Register  to view this content.

[nigelld]

Thanks stnkynts worked perfectly ;-)