Share via

Spell number formula error '#name?'

Anonymous
2015-08-24T11:43:57+00:00

I have added spellnumber formula according to directions of Microsoft forum but now it is showing #name? error. What is the reason behind it?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2015-08-24T13:21:58+00:00

    Put a simple macro in the VBE in a module and run it.   If it runs, then they are enabled.

    Sub Test()

    msgbox "Macros are enabled"

    End Sub

    (make sure your security settings aren't set to high). 

    --

    Regards,

    Tom Ogilvy

    20+ people found this answer helpful.
    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-08-24T11:49:05+00:00

    this occurs when the user defined function can not be found. 

    if you are using the code in this article:  https://support.microsoft.com/en-us/kb/213360#/en-us/kb/213360

    then see the 4 steps at the top:

    1. Start Microsoft Excel.
    2. Press ALT+F11 to start the Visual Basic Editor.
    3. On the Insert menu, click Module.
    4. Type the following code into the module sheet.

    so that is telling you to put the code in a general/standard module.  Not in a module associated with a specific sheet or in the thisworkbook module.  Putting the code in one of those modules can generally results in this type of error.  Also, I am assuming you have placed the code in the same workbook where you want to use the function.

    --

    Regards,

    Tom Ogilvy

    5 people found this answer helpful.
    0 comments
  2. Anonymous
    2015-08-24T12:33:50+00:00

    same error is appearing, i have already done the same thing before.

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2015-08-24T13:03:27+00:00

    How to check whether macros are enabled or not?

    0 comments
  4. Anonymous
    2015-08-24T12:54:50+00:00

    That is strange.  I went to the article, copied the code

    opened excel.  opened a blank workbook.   Atl+F11 to get to the Visual Basic Editor.  Insert=>Module.

    Pasted the code in that module.

    went back to Excel

    in B2 I put in 32.50

    in C1 I put in   =spellnumber(B2) 

    and it displayed:   Thirty Two Dollars and Fifty  Cents

    So I am not sure what to tell you other than to share my experience.  

    I assume macros are enabled??

    --

    Regards,

    Tom Ogilvy

    0 comments