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

C

Christo Kriel

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.
 
F

Frank Kabel

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