LinkBack URL
About LinkBacks
Hi Guys!
I have a user defined function which essentially performs a VLOOKUPand then CONCATENATES all the results in one cell. However, the result is #NAME? and I can't seem to suss it out!
Please Login or Register to view this content.
Hi Guys!
I have a user defined function which essentially performs a VLOOKUPand then CONCATENATES all the results in one cell. However, the result is #NAME? and I can't seem to suss it out!
Please Login or Register to view this content.
I don't know much about VBA, but should the first line actually be on two lines?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I don't think so, I'm quite new to VBA myself so was hoping someone here could help me out haha
From what I've seen online of User Defined Functions, they all use a similar syntax
You're getting a #NAME? error because Excel can't find the function. It needs to be in a standard code module in the workbook in which the formula appears:
1. Press Alt+F11 to open the Visual Basic Editor (VBE)
2. From the menu bar in the VBE window, do Insert > Module
3. Paste the code in the window that opens
4. Press Alt+Q to close the VBE and return to Excel
Entia non sunt multiplicanda sine necessitate
It is in its own module
One thing I just noticed is that it does not accept any ranges from another sheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks