I have in an Excel macro (in German, Excel 2000) used a "ZS" function (that
returns a cell address in the same row). I now try to transform this to
English, and can't find the english version for this function.

Hi,

If you tell us the rules for returning this cell address then perhaps
someone will be able to write you a function or formula.

Mike

"svenstar" wrote:

I have in an Excel macro (in German, Excel 2000) used a "ZS" function (that
returns a cell address in the same row). I now try to transform this to
English, and can't find the english version for this function.

Is it an Excel4 macro? You shouldn't have to translate that yourself; it
should happen automatically.

Please post the code of your macro.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"svenstar" wrote in message
...
I have in an Excel macro (in German, Excel 2000) used a "ZS" function (that
returns a cell address in the same row). I now try to transform this to
English, and can't find the english version for this function.

I try to insert a formula into a cell. The German coding in the macro was:
"Cells(freeline, 12).FormulaR1C1 =
"=SVERWEIS(ZS(-11);pt_tab;MONAT(ZS(-9))+2)"

The SVERWEIS is the VLOOKUP function, the MONAT is the MONTH, but what is ZS?


"Niek Otten" wrote:

Is it an Excel4 macro? You shouldn't have to translate that yourself; it
should happen automatically.

Please post the code of your macro.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"svenstar" wrote in message
...
I have in an Excel macro (in German, Excel 2000) used a "ZS" function (that
returns a cell address in the same row). I now try to transform this to
English, and can't find the english version for this function.

Hi,

here are all the keyword tranlations and there's no ZS function in German

http://dolf.trieschnigg.nl/excel/excel.html

So I guess the English translation is

=vlookup(ZS(-11),pt_tab,month(ZS(-9))+2)

Where ZS is an integer variable

pt_tab is a named range

Mike

"svenstar" wrote:

I try to insert a formula into a cell. The German coding in the macro was:
"Cells(freeline, 12).FormulaR1C1 =
"=SVERWEIS(ZS(-11);pt_tab;MONAT(ZS(-9))+2)"

The SVERWEIS is the VLOOKUP function, the MONAT is the MONTH, but what is ZS?


"Niek Otten" wrote:

Is it an Excel4 macro? You shouldn't have to translate that yourself; it
should happen automatically.

Please post the code of your macro.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"svenstar" wrote in message
...
I have in an Excel macro (in German, Excel 2000) used a "ZS" function (that
returns a cell address in the same row). I now try to transform this to
English, and can't find the english version for this function.

Thanks for your help, but there is definitely a ZS function in the German
Excel, I have found several other mentions of this function on the Internet
(try Google search "ZS excel funktion" for instance), but until now no
English correspondance.

Sven

"Mike H" wrote:

Hi,

here are all the keyword tranlations and there's no ZS function in German

http://dolf.trieschnigg.nl/excel/excel.html

So I guess the English translation is

=vlookup(ZS(-11),pt_tab,month(ZS(-9))+2)

Where ZS is an integer variable

pt_tab is a named range

Mike

"svenstar" wrote:

I try to insert a formula into a cell. The German coding in the macro was:
"Cells(freeline, 12).FormulaR1C1 =
"=SVERWEIS(ZS(-11);pt_tab;MONAT(ZS(-9))+2)"

The SVERWEIS is the VLOOKUP function, the MONAT is the MONTH, but what is ZS?


"Niek Otten" wrote:

Is it an Excel4 macro? You shouldn't have to translate that yourself; it
should happen automatically.

Please post the code of your macro.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"svenstar" wrote in message
...
I have in an Excel macro (in German, Excel 2000) used a "ZS" function (that
returns a cell address in the same row). I now try to transform this to
English, and can't find the english version for this function.

ZS means RC. But I think you need square brackets in the international
version, like

=vlookup(RC[-11],pt_tab,month(RC[-9])+2)

I'm a bit surprised you use the FormulaR1C1 property with a German formula.
Normally you would need the FormulaR1C1Local property to do that; the
FormulaR1C1 will always use the international (=US...) representation of the
formula.. Maybe in Excel2000 that was not yet the case?

The FormulaR1C1Local (or FormulaLocal, with A1 addressing style) is very
helpful for translating formulas. Write one style, read the other, and you
have your translation, one direction or the other.
It includes transalting special charachters, like round or square brackets,
argument separators, etc. But not any constants, that is, text between
codes, like string formats in a TEXT() function.
But you can retrieve those for the local language with the Excel4 function
GET.WORKSPACE.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel



"Mike H" wrote in message
...
Hi,

here are all the keyword tranlations and there's no ZS function in German

http://dolf.trieschnigg.nl/excel/excel.html

So I guess the English translation is

=vlookup(ZS(-11),pt_tab,month(ZS(-9))+2)

Where ZS is an integer variable

pt_tab is a named range

Mike

"svenstar" wrote:

I try to insert a formula into a cell. The German coding in the macro
was:
"Cells(freeline, 12).FormulaR1C1 =
"=SVERWEIS(ZS(-11);pt_tab;MONAT(ZS(-9))+2)"

The SVERWEIS is the VLOOKUP function, the MONAT is the MONTH, but what is
ZS?


"Niek Otten" wrote:

Is it an Excel4 macro? You shouldn't have to translate that yourself;
it
should happen automatically.

Please post the code of your macro.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"svenstar" wrote in message
...
I have in an Excel macro (in German, Excel 2000) used a "ZS" function
(that
returns a cell address in the same row). I now try to transform this
to
English, and can't find the english version for this function.

Hi,

Sorry for bothering you! By reading some other examples in the Google
replies I understand the German coding. the "Z" stands for "Zeile" ("Row")
and "S" for "Spalte" ("Column") so the translation must be:

=vlookup(RC(-11),pt_tab,month(RC(-9))+2)

"svenstar" wrote:

Thanks for your help, but there is definitely a ZS function in the German
Excel, I have found several other mentions of this function on the Internet
(try Google search "ZS excel funktion" for instance), but until now no
English correspondance.

Sven

"Mike H" wrote:

Hi,

here are all the keyword tranlations and there's no ZS function in German

http://dolf.trieschnigg.nl/excel/excel.html

So I guess the English translation is

=vlookup(ZS(-11),pt_tab,month(ZS(-9))+2)

Where ZS is an integer variable

pt_tab is a named range

Mike

"svenstar" wrote:

I try to insert a formula into a cell. The German coding in the macro was:
"Cells(freeline, 12).FormulaR1C1 =
"=SVERWEIS(ZS(-11);pt_tab;MONAT(ZS(-9))+2)"

The SVERWEIS is the VLOOKUP function, the MONAT is the MONTH, but what is ZS?


"Niek Otten" wrote:

Is it an Excel4 macro? You shouldn't have to translate that yourself; it
should happen automatically.

Please post the code of your macro.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"svenstar" wrote in message
...
I have in an Excel macro (in German, Excel 2000) used a "ZS" function (that
returns a cell address in the same row). I now try to transform this to
English, and can't find the english version for this function.

Thanks,

This answers also a lot of other questions as well. I should be able to
write better (translateable code) now!

Sven

"Niek Otten" wrote:

ZS means RC. But I think you need square brackets in the international
version, like

=vlookup(RC[-11],pt_tab,month(RC[-9])+2)

I'm a bit surprised you use the FormulaR1C1 property with a German formula.
Normally you would need the FormulaR1C1Local property to do that; the
FormulaR1C1 will always use the international (=US...) representation of the
formula.. Maybe in Excel2000 that was not yet the case?

The FormulaR1C1Local (or FormulaLocal, with A1 addressing style) is very
helpful for translating formulas. Write one style, read the other, and you
have your translation, one direction or the other.
It includes transalting special charachters, like round or square brackets,
argument separators, etc. But not any constants, that is, text between
codes, like string formats in a TEXT() function.
But you can retrieve those for the local language with the Excel4 function
GET.WORKSPACE.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel



"Mike H" wrote in message
...
Hi,

here are all the keyword tranlations and there's no ZS function in German

http://dolf.trieschnigg.nl/excel/excel.html

So I guess the English translation is

=vlookup(ZS(-11),pt_tab,month(ZS(-9))+2)

Where ZS is an integer variable

pt_tab is a named range

Mike

"svenstar" wrote:

I try to insert a formula into a cell. The German coding in the macro
was:
"Cells(freeline, 12).FormulaR1C1 =
"=SVERWEIS(ZS(-11);pt_tab;MONAT(ZS(-9))+2)"

The SVERWEIS is the VLOOKUP function, the MONAT is the MONTH, but what is
ZS?


"Niek Otten" wrote:

Is it an Excel4 macro? You shouldn't have to translate that yourself;
it
should happen automatically.

Please post the code of your macro.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"svenstar" wrote in message
...
I have in an Excel macro (in German, Excel 2000) used a "ZS" function
(that
returns a cell address in the same row). I now try to transform this
to
English, and can't find the english version for this function.