Problems with ".Names.Add Name:="name", RefersToR1C1:="=" string

[the old man]

Hi,

I have problems with above method. If length of the string is around 2075 - it works,
but if length of the strings goes around 2160 I receive error 1004 ....

Can't find any limitations for string?! (it's far beyond 65K). Please help!

Regards

 

[RoryA]

IIRC, the Name Manager stops letting you input anything at about 2084 characters.

 

[the old man]

Thanks a lot - couldn't find it ... will have to split into two names