Searching Special Characters

[shyam sundar]

Hi Friends,

Am having customer data in which some of the name may not be personalized i.e in the name some special characters might have been included (@,?,",%).

Is there any possibility to check the special characters using macro. The row ranges varies on day to day basis but column range is A to H.Name will be in the H column. If any name contains special characters that row needs to highlighted in the yellow colour.

Please help me out.

Regards
Shyam

[shyam sundar]

I got this code from online. This code is checking the entire sheet. Can this be modified into searching only the H column

Please Login or Register  to view this content.

[stnkynts]

By changing the below line you would only be searching column H. Assuming that the rest of the code works properly

Please Login or Register  to view this content.

[shyam sundar]

Thanks a lot stnkynts