View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jens Lenge Jens Lenge is offline
external usenet poster
 
Posts: 6
Default 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