Module code not being recognized
Hi, I am not yet an excel power user and am pulling my hair out over this issue. Here is my issue, any help would be greatly appreciated.
1. I have a macro-enabled spreadsheet in excel 2007.
2. I made a module and wrote some functions in it.
3. I used those functions throughout my workbook. Everything worked fine.
4. I closed and reopened the spreadsheet. Now when I update anything I get #NAME? errors for all of my user defined functions.
I sent the file to a friend, and the module with the code is present in the file. I also can see the functions if I go to Formulas->Insert Function. When I try and use a function through Formulas->Insert Function, it sets the name of the function to
'filename.xlsm'!Module1.MYFUNCTION()
which is different than what I used which was just
MYFUNCTION()
but still results in the same #NAME? error.
Really confused since the code is present in the file, and the workbook is macro enabled. Please help.
Any chance of posting a desensitised sample workbook with the functions?
Thanks for getting back to me. I can't desensitize too much sadly, but I can give you a more specific example with specific names.
In one sheet, I have cells with this value
=Impressions(L10,'Exec Summary'!G27,'Exec Summary'!G28)
In my module, named 'Module 1', the corresponding function is
Code:Public Function IMPRESSIONS(users, views, coverage) total_impressions = (users * views) / coverage IMPRESSIONS = total_impressions End Function
Last edited by Paul; 01-13-2010 at 07:07 PM. Reason: Added code tags for new user. Pcap, please use code tags around code in the future.
On another side note, when I begin to type into the formula bar, the functions show up in the typeahead search but still when I try and use one it gives a name error.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks