Microsoft KB Archive/57898

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

WINDOWS | OS/2

Summary:

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”:

=FORMULA(“=”&quot;“&ACTIVE.CELL&”&quot;&quot;&quot;)

This formula assumes the active cell is the criteria cell.

Copyright Microsoft Corporation 1993.