| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
I have had difficulty in creating user defined functions in Excel
I have been using the Wrox Excel VBA 200 book.
When I create a user defined function for use in Excel Workbook (ie typing the function directly into the cell), I get an error message name #Name? when I enter the function into a cell. This happens even when I am copying examples directrly from the book. Clearly I am doing something wrong but what is it |
|
#2
|
|||
|
|||
|
Michael,
I had a similar problem a few weeks ago... Have you tried going into tools - Add Ins - Analysis toolpak? Jim "MichaelG" wrote: I have been using the Wrox Excel VBA 200 book. When I create a user defined function for use in Excel Workbook (ie typing the function directly into the cell), I get an error message name #Name? when I enter the function into a cell. This happens even when I am copying examples directrly from the book. Clearly I am doing something wrong but what is it |
|
#3
|
|||
|
|||
|
Did you type or copy the functions into a Standard Module? It should not be
in a Worksheet, Claas or any other Module In the VB Editor: InsertModule. Enter your function there. -- Kind regards, Niek Otten Microsoft MVP - Excel "MichaelG" wrote in message ... I have been using the Wrox Excel VBA 200 book. When I create a user defined function for use in Excel Workbook (ie typing the function directly into the cell), I get an error message name #Name? when I enter the function into a cell. This happens even when I am copying examples directrly from the book. Clearly I am doing something wrong but what is it |
|
#4
|
|||
|
|||
|
Many thanks. That worked a treat!
Cheers MichaelG "Niek Otten" wrote: Did you type or copy the functions into a Standard Module? It should not be in a Worksheet, Claas or any other Module In the VB Editor: InsertModule. Enter your function there. -- Kind regards, Niek Otten Microsoft MVP - Excel "MichaelG" wrote in message ... I have been using the Wrox Excel VBA 200 book. When I create a user defined function for use in Excel Workbook (ie typing the function directly into the cell), I get an error message name #Name? when I enter the function into a cell. This happens even when I am copying examples directrly from the book. Clearly I am doing something wrong but what is it |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Default User Defined Functions - How? | Excel Discussion (Misc queries) | |||
| User Defined Variables in MS query cause a problem to import data | Excel Discussion (Misc queries) | |||
| I have user defined functions in sprdsheet. I want to put sprdsh. | Excel Worksheet Functions | |||
| user defined function row number | Excel Worksheet Functions | |||
| User defined charts- font size too small | Charts and Charting in Excel | |||
Hybrid Mode
