Well, there's a UDF, getformula() that you can create. Here's some info,
along with instructions about how to make it work:
http://www.mvps.org/dmcritchie/excel/formula.htm Post back here if you have
questions.

Dave

--
Brevity is the soul of wit.


"Bob" wrote:

Is there a way to test if a given cell contains a formula? I have tried
using the LEFT, LEN, TYPE, and CELL functions, but to no avail.
Any help would be greatly appreciated.
Thanks,
Bob