test if cell contains formula

W

wjg

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?
 
W

wjg

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
 
H

Harlan Grove

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.
 
Top