Language in CELL function

[PaulS]

Dear Excel experts,
I have the following problem. My worksheet was developed in a English version of Excel. One cell had the following contents: =IF(E8=CELL("contents";$K$5);-(G8+H8+I8+J8);""). After sending the worksheet to some users, I found most users have the Dutch version of Excel installed. All functionnames are automatically changed into language version installed, except the constant "contents" of course. (In Dutch the word "inhoud" must be used instead).
To prevent having to develop separate language versions of the workbook I have to test the language of the installed language version.
Q1: How do I test the language version installed?
Q2: Can the value "contents" be placed in a cell e.g. N37 , which then is used in the formula like: =IF(E8=CELL(N37;$K$5);-(G8+H8+I8+J8);"")

Thanks for your help,
Paul

 

[jasonb75]

Copy and paste the code into a VBA module

Public Function USERLANGUAGE()
USERLANGUAGE = Application.International(xlCountryCode)
End Function

Then test language with the formula

=IF(E8=CELL(IF(userlanguage()=31,"inhoud","contents"),$K$5),-(G8+H8+I8+J8),"")

31 is the language code for Dutch (same as the international dialing code).

Although I'm wondering why you need to use CELL("contents",$K$5) when

=IF(E8=$K$5,-(G8+H8+I8+J8),"")

should suffice, am I missing something?

 

[PaulS]

Thanks for your prompt reply.
I will use your suggestion for the macro.
You are right with your suggestion about the use of the CELL function. The reason is that I needed this function in another part of that sheet. I copied some cells with the result that in other places the function is not required.....
Thanks,
Paul