Thread: VBA automatically change text format into general format?

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.

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.

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.