How to create a function that converts formulas to .formula?

[Waimea]

Hi, I am trying to convert formulas to .formula in VBA. However, I found it hard sometimes.

Is it possible to convert a subroutine that creates .formula from formulas?

An easy example would be:

=SUM(A2:A5)

get converted to

.Formula = "=SUM(A2:A5)"

 

[DanteAmor]

If you have in formula A6 the formula =SUM(A2:A5), in the function you can put, for example:

    wformula = Range("A6").Formula
    With Range("B6")
        .Formula = wformula
    End With