sForm = range("B9").Formula
iloc = Instr(1,sForm, "=IF",vbTextcompare) Then

The results of the formula property will always be in English.

functions are stored as OP codes. So they are language independent, but you
can't access them to the best of my knowledge. If you are using the FIND
method of the range, then I guess you would need to know what the name for
"IF" is.

I believe KeepItCool has a listing of the translation of function names in
many languages.

--
Regards,
Tom Ogilvy

"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