xlm udf registration

  • Thread starter Thread starter ntoze
  • Start date Start date
N

ntoze

Hi,

I'm trying to use the xlm udf registration method from chapter 5 of the
book "Professional Excel Development". It works for 2 argument
functions, but I can't get it to work for functions with more than two
arguments. I just get a #Value! error. Has anyone else encountered this
problem?

I'm using Excel 2003 SP2.

e.g. I add an extra argument to the 'IFERROR' function in the
MFunctions module, then add one to lNumArgs in the MRegister module and
add an extra name to the argument names and an extra argument
description.


Thanks,
Nick
 
It appears that for Excel 2003 sp2, this xlm registration method
doesn't avoid the hardcoded workbook links, contrary to what is said on
page 120 of 'Professional Excel Development'. Nuts...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing a UDF as an argument to a UDF 3
Getvalue from closed workbook 1
Throwing #Value in a UDF written in Excel VBA 4
UDF's 5
XLM file and mac 0
XLM - some functions do nothing when used via defined name? 5
UDF in module of personal.xls 3
Getting values from closed workbooks 3

Back
Top