User Defined Function – problem with Parameters (XP)

Topic

New Reply

Hi All ( ),

I have an XLA that has a collection of user defined functions. I have one function with a parameter that refuses to pass the contents of a cell to the function. The parameter is defined as a string and the excel reference is =UDF(A11). When I look in debug mode, the parameter has a value “” while the cell A11 has a value of “AAAA”. Does it matter that the cell A11 is actually a lookup function that is dependent on other user defined functions?

Sorry, but I am not able to post the offending XLA. I have tried to replicate the issue in another XLA that I can post but I haven’t been able to do that. I know that this will restrict the range of help that you guys can give.

Reply | Quote

Replies

It shouldn’t matter whether A11 contains a literal value or the result of a formula.

If you can’t post the add-in, could you post the relevant code?

Reply | Quote

Problem fixed – it turns out that some of the user defined functions actually make a call on a dll and there were problems with the dll – nothing to do with excel. No wonder I couldn’t reproduce the issue with a cut down version.

Reply | Quote