Re: Testing for existence of a formula

See this:

http://j-walk.com/ss/excel/usertips/tip045.htm

Biff

"Bob" <Bob@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:18AF0994-C965-4CFD-87A3-8D7A220DF266@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: setting cell color
    ... That's not what you asked and what Bob answered to, ... "Wazooli" wrote in message ... > So then there is no way to assign a color to a cell using VBA? ... >>>> assign a color to a cell via a UDF? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Conditional Format based on contents of cell.
    ... I must admit I might use acronyms too liberally :-). ... I thought everyone knew UDF :-), but I know I shouldn't assume. ... > Hey bob, I just realised, I suggested pretty much the same thing you did ... >>> values to force the values into cells at the time of lookup.This ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Displaying when workbook was last updated
    ... Many thanks to Bob and Gord. ... I have still no idea what a UDF is but and how ... the syntax is worked out but I got the result that I wanted. ...
    (microsoft.public.excel.misc)
  • Re: using a UDF in place of a cond. format, b/c I need 4, not thre
    ... Bob -- thank you. ... I did not know that a UDF couldn't control borders. ... > Gord Dibben Excel MVP ...
    (microsoft.public.excel.misc)
  • Re: Differentiate between Number and Date?
    ... (remove nothere from the email address if mailing direct) ... > Bob Phillips wrote: ... >>In a UDF you usually do just the single action. ... >>to check the first cell in your range, passing that cell as an argument ...
    (microsoft.public.excel.misc)