+ Reply to Thread
Results 1 to 8 of 8

Ambiguous Name Detected

  1. #1
    Registered User
    Join Date
    12-05-2007
    Posts
    24

    Ambiguous Name Detected

    Hi All, I need some help with an ambiguous name detected error.


    this is the code i would like to use

    Please Login or Register  to view this content.



    Would someone be so kind as to merge them together or make it so they both work? I had this code made for me so am not qute sure how to change it


    Thanks

  2. #2
    Forum Contributor
    Join Date
    06-07-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    189

    Re: Ambiguous Name Detected

    Perhaps

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-05-2007
    Posts
    24

    Re: Ambiguous Name Detected

    Thanks for your effort

    this brings up


    Complie error

    only comments may appear after end sub, end function or end property

  4. #4
    Forum Contributor
    Join Date
    06-07-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    189

    Re: Ambiguous Name Detected

    That code compiles for me. Make sure that you have removed all the remnants of your previous code.

  5. #5
    Registered User
    Join Date
    12-05-2007
    Posts
    24

    Re: Ambiguous Name Detected

    I removed all code and it said it would delete the project, which i did

    Put code back in and now i get a runtime error 438
    Object doesn't support this property or methord



    Sheet is found here

    Please Login or Register  to view this content.

  6. #6
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,866

    Re: Ambiguous Name Detected

    Good afternoon stokie21

    You have two modules named Private Sub Worksheet_Activate.
    You can only have one sub with a particular name – this includes event procedure type modules. If you want the subs to perform both routines, lump them all together in one mod. I think that this is what Thalassa has shown you.

    HTH

    DominicB

  7. #7
    Forum Contributor
    Join Date
    06-07-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    189

    Re: Ambiguous Name Detected

    Try

    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    12-05-2007
    Posts
    24

    Re: Ambiguous Name Detected

    Thats the one


    Thank you for your help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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