Is there a function to determine whether a cell contains a formul.

[Guest]

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.

 

[Frank Kabel]

Hi
try the following UDF:
public function is_formula(rng as range)
is_formula=rng.hasformula
end function