DATA.FIND macro

Equivalent to clicking the Find and Exit Find commands on 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

Return to index