Hi Charles,

Great, barriers are there to be broken <g
Might take a while to make 64k+ names.

Regards,
Peter T

"Charles Williams" wrote in message
...
Hi Peter,

Sounds reasonable to me, I will have to to try to break the 64K barrier!

Charles
___________________________________
London Excel Users Conference April 1-2
The Excel Calculation Site
http://www.decisionmodels.com

"Peter T" <peter_t@discussions wrote in message
...
I did check a while ago following protestations from someone in this ng
and for me there was absolute limit of 64k names (ie 65,536).

I don't quite recall if that was how many could be saved rather than
created, either way that was the limit.

Regards,
Peter T

"Charles Williams" wrote in message
...
I don't know what the limit actually is, but I have seen useable
workbooks with over 50000 Defined Names

(personally I would not recommend using this many ...)

There used to be a limit on the depth of recursion allowed (names
referring to names referring to names ...),
not sure if this has been extended in Excel 2007.

Charles
___________________________________
London Excel Users Conference April 1-2
The Excel Calculation Site
http://www.decisionmodels.com

"Dean Meyer" wrote in message
...
I'm hitting a limit as well. See the posting: Limit (not memory)
consumed
by Range Names, UDF calls, VB code, st

"JNW" wrote:

Does anyone know the maximum number of named ranges allowed in xl03
and xl07?

Thanks!
--
JNW