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?