Ucase (VBA) - If "MS" then change color

Hi,

I have at the moment (from anotehr project the below code);

Please Login or Register  to view this content.

Where the W is I want it to see Ms and change the color...but it's not working and I'll explain why..

At the moment the code is looking for an exact match.. so if exact match is MS then color change...

What I have is a list of names that will be pasted into a sheet.. and where the is a Ms (female) I want the color to change

So when I change the W to Ms it only works if the cell has Ms ONLY...if it has Ms E Empty then it does not work?

Anyone have experience with this than I do?

Cheers ahead & have a happy new year.

Thanks, but thats what I was trying to say in my first post.. if I put "MS", then thats ok if the cell has ONLY ms in it..if I put a name like "Ms Newman" then it does not work because that doce is looking for MS specifically....

I need it to look at a name and if it has Ms in it, then do the action

Originally Posted by VBA Noob

Maybe

Please Login or Register  to view this content.

VBA Noob

OMG that works !!

Thanks a zillion dude !

ok now I have this broken again.

Thsi works fine if you just manually type the info in, but if you import or past infor in, then the script triggers the debugger for line;

Please Login or Register  to view this content.

Any idea's ?