Terry,
sometimes the Worksheet functions used in Excel have the same name as
those used in VBA (e.g. MID). Sometimes they have slightly different
names (e.g. RAND in Excel, Rnd in VBA). It can also happen that a
symbol is a function in Excel (MOD(5, 2)) and an operator in VBA (e.g.
5 Mod 2)

VBA Instr is served by FIND() and SEARCH(). They have identical syntax.
FIND is case sensitive and SEARCH is case-insensitive.

Does this help?
Kostis Vezerides