Identifying Cells with formulas

[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

 

[Guest]

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.

 

[Krishnakumar]

Hi,

See 'this' (http://www.j-walk.com/ss/excel/usertips/tip045.htm)

HT