Invalid pattern string (Error 93)

The pattern string specified in the Like operation of a search is invalid. This error has the following cause and solution:

  • A common example of an invalid character list expression is [a-b , where the right bracket is missing. Review the valid characters for list expressions.

For additional information, select the item in question and press F1 (in Windows) or HELP (on the Macintosh).

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.