Is there a limit to defined names?

Originally Posted by vlady

Hello tier.
just an idea..

if ever you could "shorten" the sheet names because this is also being used by the name range.. the we exceed the limit.

or maybe

divide the ranges

say
rangeA
==Sheet1!$B$5:$B$11,Sheet1!$C$5:$C$11,Sheet1!$D$5:$D$11...........

rangeB
=Sheet1!$E$5:$E$11,Sheet1!$F$5:$F$11,Sheet1!$G$5:$G$11,S..........

rangeAB
=(RangeA,RangeB)

Thanks vlady, i'll try those options as soon as I get some time later this afternoon.