Thanks Charles

I haven't used NameManager yet, but I think I'll start. Looks useful.

I'm using the named ranges for range that I have to refer to in the code.
The client loves to add columns and rows and generally mess with the format.
Using the names helps me not have to update the code everytime they want a
structure change. Any other methods out there that I have overlooked?

Thanks again.
--
JNW


"Charles Williams" wrote:

Since named ranges involve Excel doing more work they are slower than direct
references.

I have used workbooks with more than 50K names (xl97-xl07), but I would not
recommend it. Personally I would feel comfortable with up to 5K names and
with that kind of volume you probably wont hit any speed problem unless they
are all dynamic ranges or other named formulae.

Presumably you are using our Name Manager ...
http://www.decisionmodels.com/downloads.htm

Charles
__________________________________________________
Outlines for my Sessions at the Australia Excel Users Group
http://www.decisionmodels.com/OZEUC.htm

"JNW" wrote in message
...
~500 right now, but could envision hitting upwards of 5k. I figure I'm
more
than safe in 07 since they've all but done away with most memory
limitations.
I'm more worried about xl03.

Along the same lines, any known speed issues with named ranges? Is is
faster/slower? (code and worksheet references)
--
JNW


"Jim Thomlinson" wrote:

More than you could ever reasonably hope to manage... That is more of an
editorial than an answer but I can not think of a circumstance where I
would
run into the limit. What are you up to that you want to know the limit???
--
HTH...

Jim Thomlinson


"JNW" wrote:

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

Thanks!
--
JNW