Identifying Cells with formulas
 

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

In advance, thank you for your help!

Bob


--
VETcalc
------------------------------------------------------------------------
VETcalc's Profile: http://www.excelforum.com/member.php...o&userid=13078
View this thread: http://www.excelforum.com/showthread...hreadid=395346

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.
--
Gary's Student


"VETcalc" wrote:


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

In advance, thank you for your help!

Bob


--
VETcalc
------------------------------------------------------------------------
VETcalc's Profile: http://www.excelforum.com/member.php...o&userid=13078
View this thread: http://www.excelforum.com/showthread...hreadid=395346

Hi,

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

HTH


--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile: http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=395346