Named Ranges

[Guest]

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

 

[Chip Pearson]

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)

 

[Guest]

Thanks! That's what I was hoping for.

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

so no hard limit.

 

[Dean Meyer]

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