Most of the time you would use Formula.
But if for example you write a UDF that displays the formula of a cell, you
might want to display it in the adressing style that is used in the
workbook. So then you test to see what adressing style was used and choose
between Formula and FormulaR1C1. Possibly also between Formula and
FormulaLocal (and the R1C1 option of Local).
Same when you use text from the worksheet to construct a formula and write
that to a cell.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Joe" wrote in message
...
Hi all
Please point when to use each (using VBA...)
TIA
Guy