NOTE:

the FormulaR1C1 property uses english function names
and NONlocalized (std USENGLISH) separators.
=IF(;;) will give errors! and s/b like:

=IF(rc[1]1.23,9,-9)

Note that recording "formula entry" yields USEnglish formulas.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Stefi wrote :

Automation is only partly language-dependent, because a VBA script is
always in English, so transferring a sript from e.g. Swedish
environment into Hungarian the latter version will translate the
FormulaR1C1 ="IF(;;)" statement into the Hungarian =HA(;;) cell
content, even if you recorded it in Swedish as =OM(;;). Thus it will
work, EXCEPT if you have put a Swedish language formula directly in
the worksheet. This is a hypothesis, I didn't test it.
Regards,
Stefi