Macro Sheets Only
Equivalent to choosing the Find and Exit Find commands from the Data menu in Microsoft Excel version 4.0. Selects records in the database range which match criteria in the criteria range.
Syntax
DATA.FIND(logical)
Logical is a logical value that specifies whether to enter or exit the Data Find mode. If logical is TRUE, Microsoft Excel carries out the Find command; if FALSE, Microsoft Excel carries out the Exit Find command. If logical is omitted, the function toggles between Find and Exit Find.
Related Functions
DATA.FIND.NEXT Finds next matching record in a database
DATA.FIND.PREV Finds previous matching record in a database
List of Command-Equivalent Functions