Excel function

[Guest]

I want to check automatically if a cell contains a formula or a value.
Objective: execute a macro to replace the formula by its value or to put
back the formula in the cell

 

[Bob Phillips]

If Range("A1").HasFormula Then
'do something


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Hi.

Objective: execute a macro to replace the formula by its value or to put
back the formula in the cell

Which is it, replace the formula with it's value or put the formula back in
the cell. What is the criteria for doing each?

Mike