Forum Discussion

Marv_M's avatar
Marv_M
Copper Contributor
Jul 27, 2022

Error #NAME?

I am getting an error, #NAME? in .xlsm when trying to get a 128 barcode. The error is when the 
excel
Formulas and Functions
Marv_M's avatar
Marv_M
Copper Contributor
Jul 28, 2022
Correct,I mistyped it in here. Sorry
  • rachelgomez161999's avatar
    rachelgomez161999
    Iron Contributor
    Jul 29, 2022
    The #NAME error in Excel occurs when you incorrectly type the range name, refer to a deleted range name, or forget to put quotation marks around a text string in a formula. This error would have been noticed several times and this can appear for various reasons, the most common being misspelled formula.

    Solution: Correct the typo in the syntax and retry the formula. Tip: Instead of manually entering defined names in formulas, you can have Excel do it automatically for you. To do that, go to the Formulas tab, in Defined Names group, click Use in Formula, and then select the defined name you want to add.

    This may help you,
    Rachel Gomez

Resources