How to search a string contains '

L

Lucy

The Client Name in a Contacts list contains a '. When use
Find("[ClientName] = '" & sClientName & "'"), it caused
syntax error. What's the right way to do it.
 
K

Ken Slovak - [MVP - Outlook]

Add the ' character to your search string using the Chr function.
 
Top