Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Virginia Beach, Virginia, USA
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Which Function (2000)

    If you have multiple modules in a file, and in each module is a user define function ARG(..), which version is used when the function is called from a cell? In cell D5 is =ARG(C5). Which version of ARG is called?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Which Function (2000)

    You should get an "ambigous name detected" error since excel (like most of us) is wondereing why you want multiple functions with the same name.

    Steve

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Which Function (2000)

    Hi,
    Assuming all your functions are public, you should get an ambiguous name detected error. Is that not what happens to you?
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    Star Lounger
    Join Date
    Feb 2001
    Location
    Virginia Beach, Virginia, USA
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Which Function (2000)

    Sorry, no error. I expected an error when I saw how all this thrown together, but no such luck.
    Not a major problem. Just a curious oddity.
    On a parallel tack, Function calls to functons use the ones in the current module and then in other modules?

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Which Function (2000)

    As far as I know, yes, they will use the one in the same module.
    Re the formula calling the function, was the formula entered before the other identically-named function was created? If so, if you select the cell, hit f2 and then enter, do you get an error?
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    Star Lounger
    Join Date
    Feb 2001
    Location
    Virginia Beach, Virginia, USA
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Which Function (2000)

    no error when the function is updated. Perhaps my eyes are bad and the calls are different and I am just not seeing it. I have tried to reproduce this combination and I do get the error.

Posting Permissions

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