test if cell contains formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to test if a cell contains a formula / calculation or a value.
Example: Cell A2 contains the formula =B4+D7 and displays the result vs.
Cell A2 contains a number that has been directly input.
Any clues on how to accomplish?
 
Looks like the order I am seeing is different but I did see a thread for the
same issue and the suggestion to use rng.FORMULA to create custom. I'll try
that unless someone has something else better.
Thanks
Warren
 
wjg said:
Looks like the order I am seeing is different but I did see a thread
for the same issue and the suggestion to use rng.FORMULA to create
custom. I'll try that unless someone has something else better.
Click to expand...
....

There's nothing better. XLM or VBA are your only alternatives, and VBA is
more flexible.
 
Back
Top