Is there a limit when using Name Ranges?

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Is there a limit when using Name Ranges?

Post by ABabeNChrist »

I’m using Office 2007 and I was wondering before I get to deep into this workbook, is there a limit to the amount of name ranges I can use. I use these name ranges to populate drop down using data validation. I do understand that the length cannot excide 200, but what about the number of name?

User avatar
HansV
Administrator
Posts: 78466
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Is there a limit when using Name Ranges?

Post by HansV »

The maximum number of defined names is only limited by the available memory, there is no limit built into Excel.
Best wishes,
Hans

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: Is there a limit when using Name Ranges?

Post by ABabeNChrist »

Thank you HansV
Most greatly appreciated