View Single Post
  #1   Report Post  
JPP JPP is offline
Member
 
Posts: 35
Default 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!!