What is the general way of storing a formula as a String and Using the String as a Formula again?

[prabha_friend]

The Formula is:

=Sheet2!RC[11]&"" ""&Sheet2!RC[10]

How do I have to store it as a string in a cell?

'=Sheet2!RC[11]&"" ""&Sheet2!RC[10] ?
or
"=Sheet2!RC[11]&"" ""&Sheet2!RC[10] ?
or
"=Sheet2!RC[11]&"" ""&Sheet2!RC[10]" ?
or
=Sheet2!RC[11]&"" ""&Sheet2!RC[10] ? (As a Direct formula only)

How to use the stored string as a formula again (Throug VBA) ?

SomeSheet.SomeColumn.SomeRange.FormulaR1C1 = cell.value ? (Cell.value holds the formula as String)
or
SomeSheet.SomeColumn.SomeRange.Formula = cell.value ?
or
SomeSheet.SomeColumn.SomeRange.Formula = cell.formula ? (This method works for non R1C1 formulas but I don't want to see an unnecessary error field in my mapping file)

 

[oldbrewer]

can you just store a normal formula in a helper cell and use vba to go copy it and paste it wherever required ?