Ranges

Paul-Johnson

New Member
Joined
Feb 22, 2002
Messages
47
Is there a limit to the # of named ranges you can have in a workbook.

I have created some with VBA - they are in the name list box, but not available for formulas. What am I doing wrong ?

PJ
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
On 2002-02-23 18:52, Paul-Johnson wrote:
Is there a limit to the # of named ranges you can have in a workbook.

I have created some with VBA - they are in the name list box, but not available for formulas. What am I doing wrong ?

PJ

I'm not aware of any limit regarding the name space in Excel.

How many did you create?
If you're in doubt, you could eliminate a few that did work and see if the newly added ones work.

If none works in the formulas, there must be something wrong wrt their definitions.You can check this possibility by inspecting the Refers to box. By the way: What kind of errors do you get?
This message was edited by Aladin Akyurek on 2002-02-24 02:38
 
Upvote 0
FYI: Limits in Excel can be found in help under Microsoft Excel Specifications. It says the number of named ranges is limited only by available memory.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,255
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top