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