By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,594 Members | 2,016 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,594 IT Pros & Developers. It's quick & easy.

Is the Name Object limited to 256 members?

P: 2
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
Share this Question
Share on Google+
4 Replies


Expert 5K+
P: 8,434
I thought that Excel only allowed 255 or 256 worksheets in a workbook. Was I mistaken?
Nov 21 '06 #2

Expert 100+
P: 1,892
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 100+
P: 1,892
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 5K+
P: 8,434
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.