|
Hello together,
i would like to write the following Formula in one Excel Cell.
$oXL.Cells($i,13).formula = 'WENN(ISTNV(SVERWEIS(I' + $i + ';' + CHR(39) + 'TELEFON-LISTE' + chr(39) + '!A2:B210;2;FALSCH));"";SVERWEIS(I' + $i + ';' + chr(39) + 'TELEFON-LISTE' + chr(39) + '!A2:B210;2;FALSCH))'
If i do so, it works.
But if i insert the "=" bevor 'wenn' nothing is be written
If i insert the "=" in excel, the Formula works perfect.
If i write the next statement to excel, it works perfect.
$oXL.Cells($i,13).formula = '=AC' + $i
Whats wrong?
Thanks for help
Wolfgang
| 
