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