Hi "rrucksdashel" ,
If the function was installed in personal.xls then you would have to
invoke with

=personal.xls!HasFormula(A1)

Better examples for GetFormula earlier on the same page (look for usage:).
http://www.mvps.org/dmcritchie/excel...htm#getformula

More information on installling and using macros and user defined functions
http://www.mvps.org/dmcritchie/excel/getstarted.htm
http://www.mvps.org/dmcritchie/excel/install.htm

You don't normally need to include the workbook name when invoking a macro
from a different workbook as long as the workbook is open and hidden.
User Defined Functions are not macros and you have to include the
reference to the workbook when different usually by prefixing with the workbookname,

Excel can only have one workbook open with the same filename.xls
so you don't need the full pathname.

A helper column is a column added a sheet to help with such things as
- other functions, sorting, macros, conditional formatting
Typically it would be a column of the same formula (different arguments)
copied down with the fill hande.

The use of =personal.xls!HasFormula(A1) filled down with the
fill hangel would be an example of a helper column, in this case probably
just to help you visualize what you have rather than to help some other aspect of Excel.
Use of the fill handle is described in
http://www.mvps.org/dmcritchie/excel/fillhand.htm

The term "helper column" was first used, I think, by "ragdyer" on Mon, 8 Apr 2002
and it was raining somewhere in the world on that day.
http://groups.google.com/groups?thre...%40tkmsftngp04
anyway the term was obvious and quickly caught on, and has been explained
only a handful of times.

BTW, most of us do use our names in the newsgroups. "ragdyer" has stuck to
his handle as being his profession, everyone posting should be able to be
contacted in email to make full use of newsgroups. Like if something comes up
a couple of months. Many people will use a completely different email address
for newsgroups than used elsewhere..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Peo Sjoblom" wrote in message ...
http://www.mvps.org/dmcritchie/excel...htm#hasformula


"rrucksdashel" wrote...
Maybe you can help me. I have the following:
In a blank workbook, I entered 4 in A1. Then in A2 I entered
=HasFormula (A1)
It gives me this
#NAME?