Microsoft KB Archive/57898

From BetaArchive Wiki

Entering a Formula as an Exact Match in a Macro in Excel PSS ID Number: Q57898 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.x 3.00 | 2.20



Within a command macro, use the following function to convert a cell containing a text entry, such as “sam”, to an exact match entry, such as “=sam”:


This formula assumes the active cell is the criteria cell.

Copyright Microsoft Corporation 1993.