Translation for ZS into English

[svenstar]

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.

 

[Mike H]

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

 

[Niek Otten]

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

Please post the code of your macro.

 

[svenstar]

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?

 

[Mike H]

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]

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

 

[Niek Otten]

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

 

[svenstar]

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]

Thanks,

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

Sven

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

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