Excel function
 

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

Excel function
 

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


--
HTH

Bob

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

"JRem" wrote in message
...
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

Excel function
 

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

"JRem" wrote:

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