UDF error when renaming Module1

[Guest]

Hello,

I have made a UDF in Module1, but when I rename the Module1 to a name I can
easaly recognize. I have to put the full name into Excel to get it working.
Before rename: =function
After rename : =Newname.function

Is their a simple solution to my problem or is it not possible to rename
Module1.

Greetings Ronald.

 

[Ron Rosenfeld]

Hello,

I have made a UDF in Module1, but when I rename the Module1 to a name I can
easaly recognize. I have to put the full name into Excel to get it working.
Before rename: =function
After rename : =Newname.function

Is their a simple solution to my problem or is it not possible to rename
Module1.

Greetings Ronald.

This is usually due to multiple modules/functions/names with the same name.
This "same name" may be in a module in an add-in.

So you can rename module1, but you must ensure that the new name is
unambiguous.


--ron

 

[Guest]

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.

 

[Bob Phillips]

There is your ambiguity, the module and the function have the same name. Use
a different name for the module.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Ron Rosenfeld]

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