Forum Discussion

alysonpetersen's avatar
alysonpetersen
Copper Contributor
Jul 12, 2021

#NAME? error

Can someone help with the #NAME? error? I cannot find the error in my formula/syntax and need help. I have this on a calendar excel template and need the days of the month in the tops of the boxes. H...
excel
German_Chris's avatar
German_Chris
Iron Contributor
Jul 12, 2021
I guess you lost your named range DaysAndWeeks…
  • alysonpetersen's avatar
    alysonpetersen
    Copper Contributor
    Jul 12, 2021
    How would I reenter the range? I tried retyping it but got the same error
    • German_Chris's avatar
      German_Chris
      Iron Contributor
      Jul 12, 2021

      alysonpetersen 

       

      1) Ribbon "Formulas"
      2) Name Manager

      3) Search the Name

      4) Set correct Range

       

       

      • alysonpetersen's avatar
        alysonpetersen
        Copper Contributor
        Jul 12, 2021
        I am on a Mac, what would be the option instead of names manager?

Resources