Dear Toppers,

Removing apostrophe is not the problem for me. Problem is to detect and
show msgbox saying "Apostrophe detected"

Removing is working perfect if seprated from the if loop.
Please check with the if loop to detect.

Regards
ilyaskazi


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969
View this thread: http://www.excelforum.com/showthread...hreadid=395245