| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel returns @name? error when using a custom written function in
I am new to Macros and VBA.
I have written a function in VBA and it returns a #Name? error when I use it in the spreadsheet. I then tried a very simple function and that did exactly the same so I believe I dont have a syntax error. What am I dong wrong? Al |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel returns @name? error when using a custom written function in
Are you putting the function in a regular code module, rather than in a
worksheet or ThisWorkbook module? See http://www.mcgimpsey.com/excel/modules.html In article , Al Maher wrote: I am new to Macros and VBA. I have written a function in VBA and it returns a #Name? error when I use it in the spreadsheet. I then tried a very simple function and that did exactly the same so I believe I dont have a syntax error. What am I dong wrong? Al |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel returns @name? error when using a custom written function in
You need to put UDFs in a standard code module, not a sheet module, or
ThisWorkbook. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Al Maher" wrote in message ... I am new to Macros and VBA. I have written a function in VBA and it returns a #Name? error when I use it in the spreadsheet. I then tried a very simple function and that did exactly the same so I believe I dont have a syntax error. What am I dong wrong? Al |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF(AND(OR function returns #VALUE! error | Excel Worksheet Functions | |||
| #VALUE! error with custom excel vba function | Excel Discussion (Misc queries) | |||
| Excel function LARGE returns error 'too few arguments' | Excel Worksheet Functions | |||
| Why sometimes excel returns error just because function parameters are linked? | Excel Worksheet Functions | |||
| Excel forgets Custom VBA Function (#Name error) | Excel Programming | |||
Hybrid Mode
