Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Functions
I saved my user defined modules (functions) as an xla file and added that as
an AddIn to my working workbook. However, I am getting the "#Name?"error in the cells containing the user defined functions? When I go through the Insert = Functions process, I see my user defined functions listed under the user defined functions list. -- Basharat Javaid. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Functions
I'm guessing that excel is still looking for the UDF in the original location.
If that original location was a different workbook, you could use Edit|Links to point at the new .xla file. If that original location was the same workbook that contains the formula, _maybe_ this'll work. (It seemed to work ok for me.) And you'll have to do it for each UDF that you created. I created a couple of test workbooks and a UDF named myFunc(). After I moved the code from one workbook's project to the other and saved both files (one as an addin), I did this in the "regular" workbook (.xls) (with the ..xla still open). Insert|Name|define myFunc (refer to any cell) Add Then I deleted that name. insert|name|define myfunc delete Then I did edit|replace what: = (equal sign) with: = (equal sign) replace all Excel was smart enough to reevaluate this function from the xla. "Basharat A. Javaid" wrote: I saved my user defined modules (functions) as an xla file and added that as an AddIn to my working workbook. However, I am getting the "#Name?"error in the cells containing the user defined functions? When I go through the Insert = Functions process, I see my user defined functions listed under the user defined functions list. -- Basharat Javaid. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User defined functions without using VBA. | Excel Worksheet Functions | |||
User Defined Functions - Help Text - Make it Easy for the User | Excel Programming | |||
User Defined Functions | Excel Programming | |||
user defined functions | Excel Programming | |||
excel functions and User defined functions | Excel Programming |