#NAME? error in Excel for VBA Function ?

#NAME? error in Excel for VBA Function ?

Asked on October 26, 2018 in VBA.
Add Comment


  • 3 Answer(s)
    • It turned out that we “Saved As…” another file and macros weren’t enabled for that file.
    • No banner on the highest appeared, however a #NAME? error was generated.
    • we reopened the file, enabled macros, and also the drawback was resolved.
    Answered on October 26, 2018.
    Add Comment
    • The function are placed in a Standard Module.
    • The error message means Excel can’t find those function
    Answered on October 26, 2018.
    Add Comment

       Add the following line to the workbook_open event, If the order to work directly at the first time of the opening:

    ' Workbook open event
    Private Sub Workbook_Open()
      Application.CalculateFullRebuild
    End Sub
    
    Answered on October 26, 2018.
    Add Comment


  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.