Microsoft KB Archive/74343

{| = No Match Error When Using Formula Find Command in Excel =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q74343

SUMMARY
The Formula Find command selects the next or previous cell containing specified text and returns TRUE. If no matching cell is found, FALSE is returned. However, if more than one cell is selected when you use the Formula.Find macro command, or when you choose Find from the Formula menu, only the current selection is searched.

To search an entire document, it is important that the current selection be a single cell when issuing the Find command.