#name?

  • I wrote 3 UDF's, 2 of which are around 600 lines of code. I thought it would be a good idea to separate the two longer ones and put them in their own module....I went into the editor and inserted two new modules. Then I copied the functions over. The problem is that now excel doesn't recognize the function in the sheet. I get #Name? in the cells where they use to work. I tried retyping out the function and got no luck. The only thing that seems to work is pasting it back into the original module....The weirdest thing is that if I start typing out the name of the function in a cell, excel suggests the name of the function...


    Thoughts? These are all public functions. Nothing is private....