Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Naming modules / macros?

  1. #11
    Board Regular
    Join Date
    Mar 2002
    Location
    Massachusetts, USA
    Posts
    255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OK - the more I think about this, I think that the reason I am getting the multiple names & filename is because I am using this macro in multiple files. These spreadsheets need to be available to at least 10 of my analysts, so I can't save in my personal.xls.

    So, I can leave as is or change the module name back (which I will probably do, good idea klb).

    The macro works fine (thanks again Nate!!), so if it isn't broke, don't fix it.

    [ This Message was edited by: nancyo on 2002-05-07 05:59 ]

    [ This Message was edited by: nancyo on 2002-05-07 05:59 ]

  2. #12
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It's not becuase it's in multiple files, it's because there are two macros with the same name in the same workbook.

    From the macro dialog box, highlight one of the macros, click 'edit.' This will take you to the macro in question. Change:

    Code:
    sub NewTC()
    
    to 
    
    sub NewTC_2()

    If you have buttons, you may need to reassign them, but this will resolve the issue.


  3. #13
    Board Regular
    Join Date
    Mar 2002
    Location
    Massachusetts, USA
    Posts
    255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Nate - OK, I did what you said to all my files which contained the two macros(the macros still worked after I reassigned the buttons!). I now it's what you originally suggested, but I'm trying to figure things out so I can learn some of this stuff (apparently, not very well...). Why would I get duplicate copies of the same macro without trying?

    [ This Message was edited by: nancyo on 2002-05-07 09:54 ]

  4. #14
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This is learning Nancy. It's probably just an oversight, you went to one module and pasted it and went to another and pasted it by accident, no big deal (e.g., virus or lack of xl knowledge). I do it every day, that's how I'm well aquainted with the ambiguity error. Glad to see you're giving an honest effort.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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