Invalid pattern string (Error 93)

  • Article

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

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).