Simple question, search for multiple strings

[DavidSailor92]

Hi Guys!

This macro works great for 1 case, but Im trying to make this macro work for sevral situations,
(it checked if cell contains a special word, and replaces it with a full country name)

Please Login or Register  to view this content.

I would like it to work like this;

Please Login or Register  to view this content.

Anyone has any idea? This would help a lot!!

[Richard Buttrey]

Hi, and welcome to the forum.

That works for me out of the box. Can you clarify what error you get.

[DavidSailor92]

The problem is if im standing on a cell with text CA in it, it does not correct it. It only corrects the first case (BE)

Please Login or Register  to view this content.

[Richard Buttrey]

The problem is if im standing on a cell with text CA in it, it does not correct it. It only corrects the first case (BE)

Perhaps you'd better upload the actual workbook so that we can see in context. Are you sure you have "CA" and not perhaps " CA" or "CA " or "ca"?

[S O]

Not sure why you're using "Like" for literal strings...

Anyway, try this:

Please Login or Register  to view this content.

Alternatively, re-arrange your Select Case syntax like so:

Please Login or Register  to view this content.