| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Testing for existence of a formula
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Testing for existence of a formula
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Testing for existence of a formula
See this:
http://j-walk.com/ss/excel/usertips/tip045.htm Biff "Bob" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Testing for existence of a formula
Biff,
Interesting solution, although not as "simple" as I was hoping for, which was an in-cell, built-in function (and without the use of conditional formatting). There are only a few cells (versus the entire worksheet) that I want to test for the existence of a formula. Nevertheless, thanks for the suggestion. Bob "Biff" wrote: See this: http://j-walk.com/ss/excel/usertips/tip045.htm Biff "Bob" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Testing for existence of a formula
Try this:
Highlight your data range then in the menu select EditGo ToSpecialFormulaselect any format colorthen hit enter "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula structure building ? check under the excel forum.... | Excel Discussion (Misc queries) | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Hybrid Mode
