Is there a limit when using Name Ranges?
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Is there a limit when using Name Ranges?
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?
-
- Administrator
- Posts: 78474
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Is there a limit when using Name Ranges?
The maximum number of defined names is only limited by the available memory, there is no limit built into Excel.
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: Is there a limit when using Name Ranges?
Thank you HansV
Most greatly appreciated
Most greatly appreciated