=SpellNumber

Question

I  have followed the directions on how to make and use the =SpellNumber function.  When I put it in my workbook I get back #NAME?

How do I remedy this?

Answer 1

Thanks!

1. You have the code for the SpellNumber function in more than one module. This confuses Excel.
2. Some of the versions contain syntax errors.
3. The formula should simply be =SpellNumber(…)

I have uploaded a working version to DropBox:

https://www.dropbox.com/s/pgx1k7km0j5yn34/Paystubs%20with%20spelling-no%20names.xlsm?dl=1

Answer 2

You can open both workbooks: the one that already has the code, and the other one/

Then activate the Visual Basic Editor.

Drag the module from the workbook with the code to the other one and drop it. This will copy the module, making the SpellNumber function available in that workbook too.

If you want to be able to use the function in ALL workbooks, you can copy the module to your personal macro workbook Personal.xlsb.

You can then use the function as follows:

=Personal.xlsb!SpellNumber(A2)

See the following for info on Personal.xlsb:

https://support.office.com/en-gb/article/copy-your-macros-to-a-personal-macro-workbook-aa439b90-f836-4381-97f0-6e4c3f5ee566

https://www.rondebruin.nl/win/personal.htm

Answer 3

Thank you so much for your help!

Answer 4

I did copy it and pasted it into Insert> Module.

Answer 5

You should copy the code for the SpellNumber function into a standard module - the type that you create by selecting Insert > Module in the Visual Basic Editor.

It won't work if you copy the code into ThisWorkbook or into a worksheet module.