Forum Discussion

Omar_walkthru's avatar
Omar_walkthru
Copper Contributor
Dec 06, 2023

Name Range more than 50 seprate area not hapen

Hello

Greetings

Name Range more than 50 seprate area not hapen 

I dont now the problem.

 

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor

    The length of the name formula has a limit, I don't know the exact limit, but I managed to create a name with a formula of 1366 characters. If I try to name single cell areas I can name 100 areas, but if the areas are two cells, I can only name 40 areas.

Resources