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.

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.