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.