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?
      • German_Chris's avatar
        German_Chris
        Iron Contributor
        Jul 12, 2021

        alysonpetersen 

         https://apple.stackexchange.com/questions/261178/locating-name-manager-in-excel-for-mac#:~:text=There%20is%20no%20special%20button%20for%20the%20Name,click%20Insert%3EName%3EDefine%20and%20modify%2Cadd%2Cor%20delete%20data%20ranges%20names.   < Look here

         

Resources