Determining if a range of cells is missing a formula
I have a range of cells containing formulas. I'm trying to write a UDF that
will search the range and return either TRUE or FALSE if one or more cells
are missing the formula (due to someone inadvertently deleting them):
Function IsFormula(rng As Range) As Boolean
IsFormula = rng.HasFormula
End Function
Unfortunately, the UDF returns #VALUE! when a formula is missing. I would
appreciate any help in fixing the aforementioned UDF.
Thanks, Bob
|