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
|