Share via

"#NAME?

Anonymous
2023-01-04T13:31:04+00:00

Hi everyone. I wonder if any one of you can help me on this. 
I have created a module in vbs for SPELL CURRENCY but is giving me error when i use =spellcurr with values but it is giving me error of #NAME? in excel 2019, can anybody help me to resolve the issue?

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

13 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2023-01-05T12:30:38+00:00

    Thanks, that works. The function works for me:

    Could macros be disabled when you open the workbook? It would help if you made the folder containing the workbook a Trusted Location for Excel (File > Options > Trust Center > Trust Center Settings... > Trusted Locations)

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. HansV 462.6K Reputation points
    2023-01-05T07:56:48+00:00

    Could you create a stripped-down copy of the workbook demonstrating the problem (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2023-01-05T07:32:19+00:00

    Yes module is in workbook. If i create new workbook with spellcurr function that's working fine but in my previous saved workbooks giving this error. I am using ms office 2019

    Was this answer helpful?

    0 comments
  4. Anonymous
    2023-01-05T04:06:47+00:00

    Yes module is in workbook. If i create new workbook with spellcurr fuction thats working fine but in my previous saved workbooks giving this error. I am using ms office 2019

    Was this answer helpful?

    0 comments
  5. HansV 462.6K Reputation points
    2023-01-04T14:37:58+00:00

    Are you sure that the code module with the spellcurr function is present in the workbook in which you want to use it?

    Was this answer helpful?

    0 comments