Detect if a cell value is a formula
 

Hello world,

I would like to make a VBA macro detect if a certain cell contains a fixed
value or a formula.

My first idea is to compare the ".Value" and ".Formula" properties and
declare regard it as a formula if they are different. Is this a good
approach or do you suggest a better solution?

Jens

Detect if a cell value is a formula
 

?[A1].HasFormula

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Jens Lenge" wrote in message
...
Hello world,

I would like to make a VBA macro detect if a certain cell contains a fixed
value or a formula.

My first idea is to compare the ".Value" and ".Formula" properties and
declare regard it as a formula if they are different. Is this a good
approach or do you suggest a better solution?

Jens

Detect if a cell value is a formula
 

?[A1].HasFormula

Thank you!