467,151 Members | 909 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,151 developers. It's quick & easy.

Is the Name Object limited to 256 members?

I need to add the Names objects in my workbook to a Collection. However, it seems that there is never more than the first 256 objects in the MyWorkbook.Names list. I have maybe 2500 names that I need to work with. How do I expand the Names object's capability?


Dim MyWorkbook As Workbook
...
Dim DefinedNamesCollection As New Collection
...

For Each XName In MyWorkbook.Names
Set DefinedName = XName
DefinedNamesCollection.Add DefinedName, DefinedName.NameLocal
Next XName
Nov 21 '06 #1
  • viewed: 993
Share:
4 Replies
Expert 8TB
I thought that Excel only allowed 255 or 256 worksheets in a workbook. Was I mistaken?
Nov 21 '06 #2
Expert 1GB
I think with the later versions of Excel the workbook limit is based on memory not a specific number here are Microsofts spec's.
Nov 21 '06 #3
Expert 1GB
Sorry didn't read the initial post. Not sure if this applies but the specs say the names in a workbook are limited by memory. That's Excel 2003 though.
Nov 21 '06 #4
Expert 8TB
I think with the later versions of Excel the workbook limit is based on memory not a specific number here are Microsofts spec's.
Ah yes, I see. "Limited by available memory". Thanks for that, I'll bookmark that link.

So I guess the followup questions then become fairly obvious
  • What version of Excel?
  • How much memory is available?
  • Why would someone have 2500 worksheets in a workbook? Wow!
Nov 21 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

16 posts views Thread by Robert Mark Bram | last post: by
2 posts views Thread by Peter Dunker | last post: by
11 posts views Thread by Gabriel de Dietrich | last post: by
23 posts views Thread by tonytech08 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.