Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is there some kind of memory reference limit in excel?
I have the following code:
=IF('CCI Info'!DR105=0.2&'CCI Info'!DR106=0.2&'CCI Info'!DR107=0.2&'CCI Info'!DR108=0.2&'CCI Info'!DR109=0.2&'CCI Info'!DR110=0.2&'CCI Info'!DR111=0.2&'CCI Info'!DR112=0.2, 'CCI Info'!$DR$105&" "&'CCI Info'!$DR$106&" "&'CCI Info'!$DR$107&" "&'CCI Info'!$DR$108&" "&'CCI Info'!$DR$109&" "&'CCI Info'!$DR$110&" "&'CCI Info'!$DR$111&" "&'CCI Info'!$DR$112, ) And it works perfectly. But when I add line DR113 to the function, it stops working. I have code similar to this in another part of the worksheet, and it is MUCH longer. There is no reason this code shouldn't work. I have used it before, and it worked until I added : &'CCI Info'!DR113=0.2 &" "&'CCI Info'!$DR$113 After that I get a Division/0 error. Nothing changed, and this worked in my other cell. What's up? Does Excel have a limit on data or something? All I am trying to do is display multiple results in one cell!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Different kind of cell reference. | Excel Programming | |||
Reference Name - Limit? | Excel Discussion (Misc queries) | |||
Limit (not memory) consumed by Range Names, UDF calls, VB code, st | Excel Programming | |||
What kind of memory does not enough? | Excel Discussion (Misc queries) | |||
does Excel have memory limit of data Array? | Excel Programming |