Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is there a function to determine whether a cell contains a formul.
I need to use an Excel function to check whether a cell contains a formula. I
want to design a spreadsheet test for my class which checks itself and gives feedback on whether the answers are correct. |
#2
|
|||
|
|||
Hi
try the following UDF: public function is_formula(rng as range) is_formula=rng.hasformula end function -- Regards Frank Kabel Frankfurt, Germany "Christo Kriel" <Christo schrieb im Newsbeitrag ... I need to use an Excel function to check whether a cell contains a formula. I want to design a spreadsheet test for my class which checks itself and gives feedback on whether the answers are correct. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#VALUE in cell but pop up function box show right number | Excel Discussion (Misc queries) | |||
copy a cell value not its function | Excel Discussion (Misc queries) | |||
Excel - option to extend function in cell to column | Excel Worksheet Functions | |||
Function to return colour of formatted cell | Excel Worksheet Functions | |||
continuous cell function | Excel Worksheet Functions |