formula array problem
 

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



=IF(ISERROR((SUM((CallStats_Day=B7)*(CallStats_Dat e<=DATE(2004,9,19))*(CallStats_Date=DATE(2004,9,1 3))*(CallStats_Total_CL)))/(SUM((CallStats_Day=B7)*(CallStats_Date<=DATE(2004 ,9,19))*(CallStats_Date=DATE(2004,9,13))*(CallSta ts_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

formula array problem
 

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).

--
Regards,
Tom Ogilvy

"Winshent" wrote in message
om...
my code is generating the following.. it is dumped into the cell using
selection.arrayformula




=IF(ISERROR((SUM((CallStats_Day=B7)*(CallStats_Dat e<=DATE(2004,9,19))*(CallS
tats_Date=DATE(2004,9,13))*(CallStats_Total_CL)))/(SUM((CallStats_Day=B7)*(
CallStats_Date<=DATE(2004,9,19))*(CallStats_Date= DATE(2004,9,13))*(CallStat
s_Total_NoC))))=TRUE,0,((SUM((CallStats_Day=B7)*(C allStats_Date<=DATE(2004,9
,19))*(CallStats_Date=DATE(2004,9,13))*(CallStats _Total_CL)))/(SUM((CallSta
ts_Day=B7)*(CallStat

_Date<=DATE(2004,9,19))*(CallStats_Date=DATE(2004 ,9,13))*(CallStats_Total_N
oC)))))

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