Hello,
One of my custom VBA functions keeps on giving me a #Name as the result even though I can't find anything wrong with the code. After doing some testing, it turns out that the reason it's giving me a #Name is because of the module name, which is the same as the function name.
Is this not allowed in Excel? Why can't I name the module the same as the function.
thanks
No, it's not permitted - causes an uncaught error.
For function Foo, why not call your module modFoo ?
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Hi anon,
I'd expect that you need to name all things differently in code. Why does it seem strange to need to name a UDF different than a Sub or Module?
Perhaps http://www.excelforum.com/excel-gene...-function.html will help?
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
that's the way it is the recommendation is
"You can also have problems running your macros if the procedures have the same name as a module in the workbook. To avoid that, start your module names with "mod", such as modUpdate, and don't use those names for any macros."
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Doesn't seem strange but I'm just trying to keep things organized. I've never coded before (except trying to learn VBA) so still trying to get the hang of things. I guess it would make sense that 2 things need different names - just didn't know a module was a 'thing'.
Thanks for the responses.
Also good, idea. I';ll start adding 'mod' in front of my modules
It is not recommended but it is not impossible to use the same name for module and function. You must simply use =modulename.functionname() when you enter it in the cell.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks