If you do this from VBA, you might look through the .Formula property of all
cells. This property is always the English version, as opposed to the
FormulaLocal property.
If you want to use the Find method of Excel, you may benefit from
keepITcool's utility to translate functions. You can download it at

http://members.chello.nl/keepitcool/addins.html

Of course you can find all translations for your local version and back by
using the .Formula and .FormulaLocal properties.
--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"ExcelMonkey" wrote in message
...
I have a function that searches on a string that makes up a function name
say
"=IF(". Now lets assumed that I can do this perfectly, ignoring any
string
search shortfalls of VBA (I know I can use Regular Expressions too).

If I am doing this in a version of Excel that is not English say French,
the
IF Statment will likely not be the english IF. As such a search for "IF("
in
a french version - or any other version - of windows is not likely to be
productive. If I wanted to build a search function that looked for "IF("
in
every language version of Excel, what would be the best way of doing this?
Would I:

1) create a sub that recognises what language version I am in, then pass
the
correct function spelling for that function in that langauge to a variable
and search on it
2) Or are the functions just simply backed by a general library that can
be
referenced (say a ref number that is common to all IF statments in all
languages versions of Excel?

If need be where can I get the function names across all languages?


Thanks