Marco,

The FormulaR1C1 property is used for entering formulas in R1C1
style notation rather than A1 style notation. FormulaLocal is
used to enter a formula in the locale language (e.g., German or
French). Formula1 and Formula2 are used to create Data Validation
or Conditional Formatting conditions in a cell.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Marco Braun" wrote in message
...
Hey Chip,

thank you for your quick reply...

3) Use the Formula or FormulaLocal property of the Range to
place
a formula in a cell. E.g.,

Range("A1").Formula = "=SUM(B1:B10)"


this works fine, but what are the other Formulas:

FormulaR1C1
Formula1
Formula2
FormulaLocal

???
wonders on
Marco