C
Cheer-Phil-ly
Quick question...
Is there a maximum number for Named Ranges in Excel?
Is there a maximum number for Named Ranges in Excel?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
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)
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)
C
Cheer-Phil-ly
Thanks! That's what I was hoping for.
Tom Ogilvy said:from help: Names in a workbook: Limited by available memory
so no hard limit.
D
Dean Meyer
I'm running into a limit too. See my posting: Limit (not memory) consumed
by Range Names, UDF calls, VB code, st
by Range Names, UDF calls, VB code, st