Name Range more than 50 seprate area not hapen

Copper Contributor

Hello

Greetings

Name Range more than 50 seprate area not hapen 

I dont now the problem.

 

1 Reply

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.