Results 1 to 3 of 3
  1. #1
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    User Defined Function - problem with Parameters (XP)

    Hi All ( <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>),

    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.
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: User Defined Function - problem with Parameters (XP)

    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?

  3. #3
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: User Defined Function - problem with Parameters (XP)

    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.
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •