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(“=”"“&ACTIVE.CELL()&”""")
This formula assumes the active cell is the criteria cell.
Copyright Microsoft Corporation 1993.