This user defined function is not built into excel. It's a function that is
created by the user.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Short course:

Open your workbook.
Hit alt-f11 to get to the VBE (where macros/UDF's live)
hit ctrl-R to view the project explorer
Find your workbook.
should look like: VBAProject (yourfilename.xls)

right click on the project name
Insert, then Module
You should see the code window pop up on the right hand side

Paste the code in there.

Function HasFormula(cell)
HasFormula = cell.HasFormula
End Function

(From David McRitchie's site)

Now go back to excel.
Into a test cell and type:
=hasformula(a1)

wrote:

I tried using the HasFormula in the link and it doesn't work with my
Excel 2003. No referrence to it in "Help" and the function doesn't
work. I need the same function. Got any suggestions? ed

--

Dave Peterson