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
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