| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a maximun number of cells allowed in a name range?
It appears to be the case, but I don't know what the maximun is, or if my
error is for another reason. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a maximun number of cells allowed in a name range?
I don't think there is any limit...
In Excel 2003 I defined ColsBIV as =Sheet1!$B:$IV and then used =SUM(ColsBIV) in A1 result was (with 1 as the value in all cells in the range B:IV 851968 which shows that name ColsBIV refers to 851968 cells "peingle" wrote: It appears to be the case, but I don't know what the maximun is, or if my error is for another reason. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a maximun number of cells allowed in a name range?
hi
there is no maximum limit on the number of cells in a named range. what is the error you are getting??? that would be the key. so why did you not post that?!?!?! we can only help if YOU give is all the facts. regards FSt1 "peingle" wrote: It appears to be the case, but I don't know what the maximun is, or if my error is for another reason. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a maximun number of cells allowed in a name range?
Correction:
The result of the formula will give you 16711680 which is the sum of cells in 255 cols X 65,536 rows, each having a value of 1 "Sheeloo" wrote: I don't think there is any limit... In Excel 2003 I defined ColsBIV as =Sheet1!$B:$IV and then used =SUM(ColsBIV) in A1 result was (with 1 as the value in all cells in the range B:IV 851968 which shows that name ColsBIV refers to 851968 cells "peingle" wrote: It appears to be the case, but I don't know what the maximun is, or if my error is for another reason. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a maximun number of cells allowed in a name range?
Hi,
I second FSt1's response - you should always post the error message AND you should post any formulas that are failing. You also should tell us the version of Excel you are using. Possibly you are referencing an entire column, which in itself is not illegal in a range name but, if you then use the range name in certain types of formulas, in 2003 or earlier, you will get an error. Many 2003 formulas/functions did not allow full column references, those limits have been removed. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "FSt1" wrote: hi there is no maximum limit on the number of cells in a named range. what is the error you are getting??? that would be the key. so why did you not post that?!?!?! we can only help if YOU give is all the facts. regards FSt1 "peingle" wrote: It appears to be the case, but I don't know what the maximun is, or if my error is for another reason. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a maximun number of cells allowed in a name range?
There is a maximum number of characters that you can type into that insert|Name
dialog in the refers to textbox (255 maybe???). But there are ways around it. peingle wrote: It appears to be the case, but I don't know what the maximun is, or if my error is for another reason. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maximun number of hyperlinks in Excel | Excel Discussion (Misc queries) | |||
| Number of significant digits allowed in a cell is 15. | Excel Discussion (Misc queries) | |||
| max number of columns allowed | Excel Discussion (Misc queries) | |||
| Maximun number of rows and columns | Excel Discussion (Misc queries) | |||
| Pivot Table - max rows allowed in data range | Excel Discussion (Misc queries) | |||
Linear Mode
