formula array problem

[Winshent]

my code is generating the following.. it is dumped into the cell using
selection.arrayformula



=IF(ISERROR((SUM((CallStats_Day=B7)*(CallStats_Date<=DATE(2004,9,19))*(CallStats_Date>=DATE(2004,9,13))*(CallStats_Total_CL)))/(SUM((CallStats_Day=B7)*(CallStats_Date<=DATE(2004,9,19))*(CallStats_Date>=DATE(2004,9,13))*(CallStats_Total_NoC))))=TRUE,0,((SUM((CallStats_Day=B7)*(CallStats_Date<=DATE(2004,9,19))*(CallStats_Date>=DATE(2004,9,13))*(CallStats_Total_CL)))/(SUM((CallStats_Day=B7)*(CallStat
_Date<=DATE(2004,9,19))*(CallStats_Date>=DATE(2004,9,13))*(CallStats_Total_NoC)))))

however i get the following error. i dont understand why this is a
problem as i have a totals cell which gets pasted with same as above
except no limits on dates.. and it works fine..

also when i dump the above into the cell after using debug.print... it
works fine and proves there isnt a mistake with brackets etc..

surely there must be a work around for this?

many thanks in advance

Vincent

 

[Tom Ogilvy]

Your string has a length of 483 characters, but FormulaArray is limited to
strings of 255 characters (measured with the formula expressed in R1C1
format).