Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDF error when renaming Module1
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDF error when renaming Module1
On Sat, 27 Nov 2004 04:35:13 -0800, "RonaldF"
wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDF error when renaming Module1
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. "Ron Rosenfeld" wrote: On Sat, 27 Nov 2004 04:35:13 -0800, "RonaldF" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDF error when renaming Module1
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) "RonaldF" wrote in message ... 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. "Ron Rosenfeld" wrote: On Sat, 27 Nov 2004 04:35:13 -0800, "RonaldF" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDF error when renaming Module1
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Renaming cells tedious and error prone | New Users to Excel | |||
Renaming Worksheet: Error message: "Reserved Name" | Excel Discussion (Misc queries) | |||
size/space problem with module1 in VB even though it is empty | Excel Programming | |||
Renaming | Excel Programming | |||
Error trap the renaming of a sheet to an existing one | Excel Programming |