On Sat, 27 Nov 2004 05:49:07 -0800, "RonaldF"
wrote:

Hello Ron,

I have tested it, but when I rename Module1 to LH2005 (the name of the
function) then I have to put in Excel to activate the function
"=LH2005.LH2005(values)" to get it working.

I just want to put "=LH2005(values)" in stead of "=LH2005.LH2005(values)".

Greetings Ronald.

Read again what I wrote.

"This is usually due to multiple modules/functions/names with the same name."

You have set up a situation where your *module* and your *function* have the
SAME name. (LH2005).

I emphasize that this is an ambiguous situation. Excel cannot know, when you
type LH2005, if you are referring to the *module* or to the *function*.

If you don't want to have to specify both, you cannot give both of them
IDENTICAL names!!!




--ron