I believe a formulaArray formula is restricted to a length of 255 characters
and yours appears to be longer than that.

--
Regards,
Tom Ogilvy

"Kohai" wrote in message
...
Hi,

I have a formula I am running in a workbook to calculate
the averages of a column based on values in another
column. I ran this same code on another workbook last
week without any problems, but this time I am getting the
Run Rime Error -

1004 - Unable to Set the FormulaArray Property of the
Range Class

ActiveCell.FormulaArray = "=IF(ISERROR(AVERAGE(IF
([NUMEARNEST_30_60d_" & EDate & ".xls]30d_win!$B$4:$B" & _
lRow & "=C10,[NUMEARNEST_30_60d_" & _
EDate & ".xls]30d_win!$R$4:$R$" & lRow
& "))),0.000,AVERAGE(IF([NUMEARNEST_30_60d_" & _
EDate & ".xls]30d_win!$B$4:$B$" & lRow & "=C10,
[NUMEARNEST_30_60d_" & _
EDate & ".xls]30d_win!$R$4:$R$" & lRow & ")))"

The formula works fine if I manually enter it and create
the array, only in VBA does it give the error. I'm using
XCL '02. How can I get around this error. I have lots
of these calculations to do for many dates.

Thx a bunch!

Kohai