Identifying Cells with formulas

V

VETcalc

I am aware of the VBA approach to identifying Cells with formulas. M
question,
is there anyway to use a Excel Function with logic to identifying
cell that contains
a formula?

In advance, thank you for your help!

Bo
 
G

Gary's Student

Please ignore this answer if some one can help you without resorting to UDFs.
Otherwise this tiny UDF:

Function IsFormula(cell As Range) As Boolean
IsFormula = cell.HasFormula
End Function

will tell you TRUE/FALSE if cell has a formula.
 
Top