too many named ranges?

  • Thread starter Thread starter Danny
  • Start date Start date
D

Danny

I have created several named ranges and they are for list box data
validation. Some of the ranges are over 1000 rows long, and I am also
setting data validtion to 1000's of rows and I think I just got a message
that there is no more room or memory.

Is this a problem?

What else can I do for the look up tables?

Thanks again
 
You do not say what your system specifications are, and softwar
versions you are using.

Looking up in Excel Help "limits in Microsoft Excel" it shows tha
numer of names is limited by available system memory. The size of rang
referred to would have no bearing.

The suggestion is that you have run out of memory.
1. Try closing other applications down.
2. you can increase virtual memory (on disk) by changing the size o
your Windows pagefile.
3. Purchase some more memory (RAM)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return Just the Unique Entries From a Range of Cells 3
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Add Subtotal functions using cell references 2
Can't located named range 3
Excel VBA - counting cells by colors and names to it in two different rows. 0
VBA - retrieve data on last create named range from previous inserted named range 0
sorting range 1
Excel Need Countifs Formula Help 0

Back
Top