FORMULA.FIND.NEXT, FORMULA.FIND.PREV macro

Finds the next and previous cells on the worksheet, as specified in the Find dialog box, and returns TRUE. (To see the Find dialog box, click Find on the Edit menu.) If a matching cell is not found, the functions return FALSE. For more information see FORMULA.FIND.

Syntax

FORMULA.FIND.NEXT( )

FORMULA.FIND.PREV( )

Related Functions

DATA.FIND   Selects records in a database that match the specified criteria

FORMULA.FIND   Finds text in a workbook

Return to index