Hi thank you
so simple and it works, cool

Die_Another_Day wrote:
Try setting the formula of the destination cells to the text of the
host cells like this:

Range("A1").Formula = Range("A2").Text

HTH

Die_Another_Day

Nicawette wrote:
Hi,

I've a macro which can copy cell(s) containing formula in text format
into other cell(s).
I want to activate these formulas automatically when they are in the
destination cell. For the time being I have to go in each cell and
activate the formula by hitting enter. Is it possible to do it
automatically, something that I can add at the end of my macro ?

Thank you

Nic.