View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Testing for existence of a formula

Dave,
Thanks for your help. I was hoping to utilize one of Excel's built-in
functions without resorting to a UDF. But if that's the only way to do it,
then I guess I'll have to use the UDF.
Thanks again,
Bob


"Dave F" wrote:

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