+ Reply to Thread
Results 1 to 3 of 3

Error "Ambiguous name detected: My Function Name" after function has been used for months

  1. #1
    Forum Contributor
    Join Date
    07-11-2010
    Location
    Minneapolis, USA
    MS-Off Ver
    Excel 2016
    Posts
    308

    Error "Ambiguous name detected: My Function Name" after function has been used for months

    I am getting the error "Ambiguous name detected: My Function Name" this has happened a couple of times always I have been using the function since the project began this could be a year.

    Then one day I open the workbook and I get the error message?

    In this instance I get

    "Ambiguous name detected: goFast" I use this everywhere in all my projects with never a problem, in this project for the last 7 months, I use it like so:

    Please Login or Register  to view this content.
    If I comment out the goFast excel just finds the next instance and gives the same error

    Any ideas what is going on here it is kinda freaking me out

    Thanks

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Error "Ambiguous name detected: My Function Name" after function has been used for mon

    Do you have anything else, eg module, function, codename etc, called 'gofast'?

    Also do you have this repeated anywhere?
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    07-11-2010
    Location
    Minneapolis, USA
    MS-Off Ver
    Excel 2016
    Posts
    308

    Re: Error "Ambiguous name detected: My Function Name" after function has been used for mon

    Hello Norie, yes it turns out, a friend sent me a .bas module with some code in it and he had the sub called goFast in it (which I had sent him maybe a year ago) and I did not catch it

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Getting "this function takes no arguments" and "#NAME?" error
    By chuckmckiel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-31-2014, 01:58 PM
  2. VBA Compile Error: Ambiguous name detected
    By kieranoduill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2013, 05:31 PM
  3. [SOLVED] How to overcome "Compile Error – Ambigious name detected – Run When"
    By Kanga1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-23-2013, 03:27 PM
  4. Replies: 3
    Last Post: 04-02-2013, 08:41 AM
  5. [SOLVED] compile error ambiguous name detected!?
    By Margate in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2013, 08:49 PM
  6. Ambiguous name detected error
    By jpxexcelforum in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-07-2011, 06:04 PM
  7. "Ambiguous name detected: FormatCell"
    By copleyr in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 09-05-2009, 10:16 AM
  8. Compile error: Ambiguous name detected
    By Aletha in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-05-2008, 05:48 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1