Named Ranges
 

Quick question...
Is there a maximum number for Named Ranges in Excel?

Named Ranges
 

There is no specific limit. It depends on the memory available to Excel. I
have worked on applications with thousands of defined names. If you are
working with even hundreds of defined names, you are well within the limits
of Excel.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Cheer-Phil-ly" wrote in message
...
Quick question...
Is there a maximum number for Named Ranges in Excel?

Named Ranges
 

Thanks! That's what I was hoping for.

"Tom Ogilvy" wrote:

from help: Names in a workbook: Limited by available memory

so no hard limit.

--
Regards,
Tom Ogilvy



"Cheer-Phil-ly" wrote:

Quick question...
Is there a maximum number for Named Ranges in Excel?

Named Ranges
 

I'm running into a limit too. See my posting: Limit (not memory) consumed
by Range Names, UDF calls, VB code, st

"Cheer-Phil-ly" wrote:

Quick question...
Is there a maximum number for Named Ranges in Excel?